Backup & Restore Problem 
July 4th, 2009, 03:03 PM
| | Member | | Join Date: Sep 2007
Posts: 71
| | |
Hi
I have a database named textile.I have 10 tables in it.I have used the following command to backup my database as SQL Script file, mysqldump -u sa -p textile>textile.sql
The above command is successful and i have dropped my textile database.
Now i have created new database with same name textile and i used the following command to restore my database, mysqldump -u sa -p textile<textile.sql
The above command also successfully working but when i use the database and try to access any table,it is showing error that the table doesn't exist. I want all the tables and its data along with my backup in order to restore.
Please help in this issue...and direct me accordingly.
Thanks in advance...
| 
July 4th, 2009, 04:41 PM
| | Member | | Join Date: Aug 2007
Posts: 119
| | | re: Backup & Restore Problem
Your syntax looks fine. I wonder if it might be a permissions issue with the new database? Maybe you could try this question in the Linux forum.
| 
July 4th, 2009, 04:49 PM
| | Member | | Join Date: Sep 2007
Posts: 71
| | | re: Backup & Restore Problem
Hi
I don't know anything about linux.I am using Windows XP.
Please help me in this issue.
| 
July 4th, 2009, 05:08 PM
| | Member | | Join Date: Sep 2007
Posts: 71
| | | re: Backup & Restore Problem
Hi
Please help me quickly. I am fed up with this matter.
| 
July 4th, 2009, 05:12 PM
| | Member | | Join Date: Aug 2007
Posts: 119
| | | re: Backup & Restore Problem
My mistake, sorry. I've never used XP as a server so I'm afraid I won't be of much help to you.
I can tell you are frustrated and I hope that someone will be able to help you in the time limit you have imposed.
| 
July 4th, 2009, 05:32 PM
| | Member | | Join Date: Sep 2007
Posts: 71
| | | re: Backup & Restore Problem
Hi
Thank you for your support. I have downloaded a software "Navicat for MySQL Enterprise Edition 8.2".It is a GUI software similar to SQL Server 2000 and i used it to bacup my MySQL database. It worked successfully.
But still it is a third party software...
What to do...
Thanks for your help...
| 
July 4th, 2009, 07:12 PM
| | Member | | Join Date: Feb 2009
Posts: 54
| | | re: Backup & Restore Problem
Why don't you do the same thing using Mysql Administrator??
| 
July 5th, 2009, 04:08 AM
| | Member | | Join Date: Sep 2007
Posts: 71
| | | re: Backup & Restore Problem
Hi
I am using MySQL Server 5.1 which works in the dos environment and not a GUI tool.
There is no MySQL Administrator component in MySQL Server 5.1.
Where is it? Whether i need to download it seperately?
If so give me the download link also.
Thanks....
| 
July 5th, 2009, 04:28 PM
| | Member | | Join Date: Sep 2007
Posts: 71
| | | re: Backup & Restore Problem
Hi
I have downloaded and installed MySQL GUI Tool,backed up my database and restored the same successfully.
Thanks for your help and support...
Keep in touch with me....
|  | | | | /bytes/about
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 225,662 network members.
|