Hi, I hope I can get help through here. I am trying to create a copy of my vBulletin forums at sc2mx.com so I can manage one as a development system and the other as production system, so to speak.
My production database is romri_sc2mx, my new development database is romri_sc2mx_dev. I am trying to migrate all content from the former to the latter.
I created an sql dump from romri_sc2mx using phpMyAdmin called localhost3.sql but when I try to import it into romri_sc2mx_dev, I get the following:
I cannot import through phpMyAdmin because the SQL dump is too big (lol).
Any help with this issue is greatly appreciated!
asked May 29 '11 at 21:18
It seems your SQl dump contains the dump for information_schema table which is a system table hence inaccessible to normal users.
You would need to remove any lines referring to that database from the dump for it to be successful.
Please also make sure that the dump contains the tables and data only for a s ingle database which is "romri_sc2mx_dev" in this case.
Hope that helps!
answered May 29 '11 at 21:32