Backup & Restore Problem

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...

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.

re: Backup & Restore Problem

Hi

I don't know anything about linux.I am using Windows XP.

Please help me in this issue.

re: Backup & Restore Problem

Hi

Please help me quickly. I am fed up with this matter.

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.

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...

re: Backup & Restore Problem

Why don't you do the same thing using Mysql Administrator??

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....

re: Backup & Restore Problem

You can download the same from the link below:
http://dev.mysql.com/downloads/gui-tools/5.0.html

Thanks,
Lauren

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....