Hello,
I recently migrated a client from a Plesk instance that had phpmyadmin and the phpmyadmin foreign key browse enabled. The new server does not use Plesk and I've been having a heck of a time setting this function up again. I've setup the phpmyadmin database, but I did so after I imported the database. Was wondering If I had to reimport the DB again since this function had to be enabled prior to the import.
Thanks
kmitchell@hosting.com | Facebookhttp://www.facebook.com/#!/pages/Hostingcom/83819275924?ref=ts| Twitterhttp://twitter.com/hostingdotcom| Linkedinhttp://www.linkedin.com/in/keithdmitchell27 |
Keith D. Mitchell a écrit :
Hello,
I recently migrated a client from a Plesk instance that had phpmyadmin and the phpmyadmin foreign key browse enabled. The new server does not use Plesk and I’ve been having a heck of a time setting this function up again. I’ve setup the phpmyadmin database, but I did so after I imported the database. Was wondering If I had to reimport the DB again since this function had to be enabled prior to the import.
(Please use the phpmyadmin-users mailing list next time)
If you look in your phpmyadmin.pma_table_info and pma_relation, are your relations there?
(sorry for using wrong list)
I looked in both tables and they are empty.
Thanks -----Original Message----- From: Marc Delisle [mailto:marc@infomarc.info] Sent: Tuesday, June 08, 2010 1:12 PM To: phpmyadmin-devel@lists.sourceforge.net Subject: Re: [Phpmyadmin-devel] Setting up phpmyadmin foreign key browse
Keith D. Mitchell a écrit :
Hello,
I recently migrated a client from a Plesk instance that had phpmyadmin and the phpmyadmin foreign key browse enabled. The new server does not use Plesk and I've been having a heck of a time setting this function up again. I've setup the phpmyadmin database, but I did so after I imported the database. Was wondering If I had to reimport the DB again since this function had to be enabled prior to the import.
(Please use the phpmyadmin-users mailing list next time)
If you look in your phpmyadmin.pma_table_info and pma_relation, are your relations there?
Keith D. Mitchell a écrit :
(sorry for using wrong list)
I looked in both tables and they are empty.
So use your backup of these tables to populate them.
Thanks -----Original Message----- From: Marc Delisle [mailto:marc@infomarc.info] Sent: Tuesday, June 08, 2010 1:12 PM To: phpmyadmin-devel@lists.sourceforge.net Subject: Re: [Phpmyadmin-devel] Setting up phpmyadmin foreign key browse
Keith D. Mitchell a écrit :
Hello,
I recently migrated a client from a Plesk instance that had phpmyadmin and the phpmyadmin foreign key browse enabled. The new server does not use Plesk and I've been having a heck of a time setting this function up again. I've setup the phpmyadmin database, but I did so after I imported the database. Was wondering If I had to reimport the DB again since this function had to be enabled prior to the import.
(Please use the phpmyadmin-users mailing list next time)
If you look in your phpmyadmin.pma_table_info and pma_relation, are your relations there?
I tried that already. On the source server they are also blank. I don't know if Plesk puts them in a different location or naming structure. But I can access this on the original server, there is no different between the DB that was moved or the phpmyadmin configuration.
ph: 720.389.3865 | fax: 720.389.3876 | gen: 866.918.4678 jsackheim@hosting.com | Facebook | Twitter | LinkedIn
Flex, Scale, Secure Your Infrastructure – Go Hybrid ________________________________________ From: Marc Delisle [marc@infomarc.info] Sent: Tuesday, June 08, 2010 1:19 PM To: phpmyadmin-devel@lists.sourceforge.net Subject: Re: [Phpmyadmin-devel] Setting up phpmyadmin foreign key browse
Keith D. Mitchell a écrit :
(sorry for using wrong list)
I looked in both tables and they are empty.
So use your backup of these tables to populate them.
Thanks -----Original Message----- From: Marc Delisle [mailto:marc@infomarc.info] Sent: Tuesday, June 08, 2010 1:12 PM To: phpmyadmin-devel@lists.sourceforge.net Subject: Re: [Phpmyadmin-devel] Setting up phpmyadmin foreign key browse
Keith D. Mitchell a écrit :
Hello,
I recently migrated a client from a Plesk instance that had phpmyadmin and the phpmyadmin foreign key browse enabled. The new server does not use Plesk and I've been having a heck of a time setting this function up again. I've setup the phpmyadmin database, but I did so after I imported the database. Was wondering If I had to reimport the DB again since this function had to be enabled prior to the import.
(Please use the phpmyadmin-users mailing list next time)
If you look in your phpmyadmin.pma_table_info and pma_relation, are your relations there?
-- Marc Delisle http://infomarc.info
------------------------------------------------------------------------------ ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Keith D. Mitchell a écrit :
I tried that already. On the source server they are also blank. I don't know if Plesk puts them in a different location or naming structure. But I can access this on the original server, there is no different between the DB that was moved or the phpmyadmin configuration.
I would guess that on the source server, the tables you are seeing have always been empty and that the real ones were elsewhere and configured as such in phpMyAdmin.