List:General Discussion« Previous MessageNext Message »
From:Daevid Vincent Date:May 25 2010 11:06pm
Subject:RE: source backup.sql - troubleshoot
View as plain text  
Use something like SQLYog, load your .sql file into the editor, run all the
commands one at a time, or in bulk.  Look at the "info" window for what
line failed.

> -----Original Message-----
> From: Sydney Puente [mailto:sydneypuente@stripped] 
> Sent: Tuesday, May 25, 2010 2:39 PM
> To: mysql@stripped
> Subject: source backup.sql - troubleshoot
> 
> Hello,
> 
> I have a mysqldump file created by AutoMySQLBackup.
> And it hangs when I do a 
> mysql > source backup.sql
> It is 32 MB - it creates 4 tables and after creation of each 
> table it populates it.
> Actually it only creates the 1st table before hanging.
> 
> My first thought is it would be nice to echo each of the 
> commands it is executing so I can tell whoch command it is 
> that is the problem.
> My second thought is that there must be a quite a few 
> troubleshooting techniques i could/should use - except I dont 
> know hwtat they are.
> 
> All advice gratefully received!
> 
> BTW Platform redhat 5.2,   Server version       5.0.54a-enterprise
> 
> -Syd
> 
> 
>       
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    
> http://lists.mysql.com/mysql?unsub=1
> 

Thread
source backup.sql - troubleshootSydney Puente25 May
  • RE: source backup.sql - troubleshootDaevid Vincent26 May
  • Re: source backup.sql - troubleshootRob Wultsch26 May
  • Re: source backup.sql - troubleshoota.smith26 May
    • Re: source backup.sql - troubleshootJohan De Meersman26 May
      • Re: source backup.sql - troubleshoota.smith26 May
        • Re: source backup.sql - troubleshootJohan De Meersman26 May
          • Re: source backup.sql - troubleshootSydney Puente26 May
            • Re: source backup.sql - troubleshootJohan De Meersman26 May
              • Re: source backup.sql - troubleshootSydney Puente26 May
                • Re: source backup.sql - troubleshootJohan De Meersman26 May
                  • Re: source backup.sql - troubleshootSydney Puente26 May
                    • Re: source backup.sql - troubleshootJohan De Meersman26 May
            • Re: source backup.sql - troubleshootDimitre Radoulov26 May