MySQL Forums
Forum List  »  Backup

Mysql phpmyadmin Backup
Posted by: Sam Al Shami
Date: July 04, 2013 07:48PM

Hello Everyone,

I have a joomla website that I need to copy to a new host online. I took a backup of the database (Mysql).
When I wanted to restore the database using phpmyadmin from the control panel of the hosting company. I noticed that the sql dump file that i have contains an information schema backup too.
my question is that will this effect other databases too in my host because I hhave other databases (Word press and other). if yes how can I remove these parts in the sql file.

2. even when I restore the file using phpmyadmin I get syntax errors:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version

please note that I have no access to the original database any more. is there some thing I can do?

Options: ReplyQuote

Written By
Mysql phpmyadmin Backup
July 04, 2013 07:48PM
July 05, 2013 10:57PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.