473,467 Members | 1,373 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Backup & Restore Problem

87 New Member
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...
Jul 4 '09 #1
9 2448
Annalyzer
122 New Member
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.
Jul 4 '09 #2
Ananthu
87 New Member
Hi

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

Please help me in this issue.
Jul 4 '09 #3
Ananthu
87 New Member
Hi

Please help me quickly. I am fed up with this matter.
Jul 4 '09 #4
Annalyzer
122 New Member
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.
Jul 4 '09 #5
Ananthu
87 New Member
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...
Jul 4 '09 #6
SLauren
60 New Member
Why don't you do the same thing using Mysql Administrator??
Jul 4 '09 #7
Ananthu
87 New Member
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....
Jul 5 '09 #8
SLauren
60 New Member
You can download the same from the link below:
http://dev.mysql.com/downloads/gui-tools/5.0.html

Thanks,
Lauren
Jul 5 '09 #9
Ananthu
87 New Member
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....
Jul 5 '09 #10

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: James | last post by:
HI, I'm looking for a script that will allow users/admins to have a one click backup solution for a MYSQL Database.. 'BACK DATABASE' button, click and its done... The a restore option, that...
1
by: L. Bertolini | last post by:
We're considering purchasing an application, which stores some data in the filesystem, and some data (meta data and links to files) in MS-SQL. We need to be able to create a backup wherein the...
2
by: Spieg | last post by:
I've a program with VB6 working with SQLServer 2000. I have a Central Station with the program runnin with full prvileges and that can perform all the actions on the DB. There are also some...
3
by: butatista | last post by:
Please help SQL Server 2000 Standard I am trying to restore databases on my server and am unable to get them to restore using the database option. For example, the location of my backup...
2
by: Vikrant | last post by:
Friends, I have read DB2/UDB 8.x 'RESTORE DATABASE Command', with my 'limited' knowledge & skill. I think it should address my concern, but I want advice/ opinion / experience and any care I...
6
by: Eric Herber | last post by:
I've a question regarding db2 (V8.1) and database backups going to a storage manager like TSM for example. As I can see in the storage manager if I backup the complete database over the TSM API...
4
by: Hardy | last post by:
hi gurus, now I have to backup and restore a 8 T size db2 database. from two s85 to two 670. the partitions,tablespaces of the db should be redesigned then I plan to use redirected restore. but...
2
by: NEXUZ6 | last post by:
Can I restore a backup taken from a DB2 7.2 on Linux to a 8.1 Win ? How ? Tkx
0
by: prerak_v_shah | last post by:
Hi All, These days I was working on IBM DB2 database for windows with my .Net Application. Now, it was required to backup database created on one machine to the other machine. I was also able...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.