Backup & Restore Problem

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Ananthu
    New Member
    • Sep 2007
    • 87
    #1

    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...
    Tags: None
    • Annalyzer
      New Member
      • Aug 2007
      • 122
      #2
      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.

        Comment

        • Ananthu
          New Member
          • Sep 2007
          • 87
          #3
          Working in Windows XP

          Hi

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

          Please help me in this issue.

            Comment

            • Ananthu
              New Member
              • Sep 2007
              • 87
              #4
              Urgent Help

              Hi

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

                Comment

                • Annalyzer
                  New Member
                  • Aug 2007
                  • 122
                  #5
                  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.

                    Comment

                    • Ananthu
                      New Member
                      • Sep 2007
                      • 87
                      #6
                      Thanks

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

                        Comment

                        • SLauren
                          New Member
                          • Feb 2009
                          • 60
                          #7
                          Why don't you do the same thing using Mysql Administrator??

                            Comment

                            • Ananthu
                              New Member
                              • Sep 2007
                              • 87
                              #8
                              MySQL Administrator

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

                                Comment

                                • SLauren
                                  New Member
                                  • Feb 2009
                                  • 60
                                  #9
                                  You can download the same from the link below:
                                  fw_error_www
                                  http://dev.mysql.com/downloads/gui-tools/5.0.html


                                  Thanks,
                                  Lauren

                                    Comment

                                    • Ananthu
                                      New Member
                                      • Sep 2007
                                      • 87
                                      #10
                                      Thanks

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

                                        Comment

                                        Previous template Next
                                        Working...