Mandatory information about my setup:
Have I read the related troubleshooter articles above before posting (which pages?)? Yup
Have I searched the tickets before posting? A while back I did, but not today.
Have I read the documentation before posting (which pages?)? Ditto
Joomla! version: (unknown) 2.5.11 now, but was 2.5.9 when I had the issue
PHP version: (unknown)
MySQL version: (unknown)
Host: (optional, but it helps us help you) CPanel
Akeeba Backup version which took the backup: (unknown) Previous version
Kickstart version used to extract the backup: (unknown) Current as of 3-4 weeks ago.
Description of my issue:
I haven't been able to log on and submit tickets, because this site has been unavailable during any times that I could get to it (evening Central US time).
I had this problem a while back, so I'm just reporting it in a general sense. I was able to use phpMyAdmin to fix my own problem at the time. Sorry for the level of vagueness.
I did a vanilla install on Cpanel, to set up a database, password, user, etc. The intention was to overwrite this with a restore from my WAMP server. I've done this dozens of times in the past few years.
The vanilla CPanel install of Joomla 2.5.9 had a 4 character prefix (Ex: abcd_)
My new install had a 5 character prefix Ex: "vwxyz_" in the backup. The 5 char prefix was in the "drop these tables" section, but I changed it to the 4 character prefix. After running, the database still had the 4 character prefix tables PLUS some new 5 character prefix tables. The configuration.php also had the 4 char prefix (if I recall correctly).
My restore obviously had additional tables (due to extra components, etc). That's why the resulting database had a mix of 4 and 5 character prefixes.
If I need to recreate this scenario for you, please let me know.
Have I read the related troubleshooter articles above before posting (which pages?)? Yup
Have I searched the tickets before posting? A while back I did, but not today.
Have I read the documentation before posting (which pages?)? Ditto
Joomla! version: (unknown) 2.5.11 now, but was 2.5.9 when I had the issue
PHP version: (unknown)
MySQL version: (unknown)
Host: (optional, but it helps us help you) CPanel
Akeeba Backup version which took the backup: (unknown) Previous version
Kickstart version used to extract the backup: (unknown) Current as of 3-4 weeks ago.
Description of my issue:
I haven't been able to log on and submit tickets, because this site has been unavailable during any times that I could get to it (evening Central US time).
I had this problem a while back, so I'm just reporting it in a general sense. I was able to use phpMyAdmin to fix my own problem at the time. Sorry for the level of vagueness.
I did a vanilla install on Cpanel, to set up a database, password, user, etc. The intention was to overwrite this with a restore from my WAMP server. I've done this dozens of times in the past few years.
The vanilla CPanel install of Joomla 2.5.9 had a 4 character prefix (Ex: abcd_)
My new install had a 5 character prefix Ex: "vwxyz_" in the backup. The 5 char prefix was in the "drop these tables" section, but I changed it to the 4 character prefix. After running, the database still had the 4 character prefix tables PLUS some new 5 character prefix tables. The configuration.php also had the 4 char prefix (if I recall correctly).
My restore obviously had additional tables (due to extra components, etc). That's why the resulting database had a mix of 4 and 5 character prefixes.
If I need to recreate this scenario for you, please let me know.
