Backup SQL

2006-08-04 Thread Kaushal Shriyan
Hi I have a query is i have taken backup from druapl due to timeout error in three backup files a-l.sql m-s.sql t-z.sql Now my understanding is if i do mysql -u kaushal -h example.com -p drupal /home/kaushal/drupal/new/a-l.sql and then do mysql -u kaushal -h example.com -p drupal

Re: Backup SQL

2006-08-04 Thread Chris White
On Friday 04 August 2006 04:04 am, Kaushal Shriyan wrote: mysql -u kaushal -h example.com -p drupal /home/kaushal/drupal/new/a-l.sql and then do mysql -u kaushal -h example.com -p drupal /home/kaushal/drupal/new/m-s.sql Better would be: mysql -u kaushal -h example.com -p drupal

Re: Backup SQL

2006-08-04 Thread Daniel da Veiga
On 8/4/06, Chris White [EMAIL PROTECTED] wrote: On Friday 04 August 2006 04:04 am, Kaushal Shriyan wrote: mysql -u kaushal -h example.com -p drupal /home/kaushal/drupal/new/a-l.sql and then do mysql -u kaushal -h example.com -p drupal /home/kaushal/drupal/new/m-s.sql Better would be:

Re: Backup SQL

2006-08-04 Thread Chris White
On Friday 04 August 2006 10:35 am, Daniel da Veiga wrote: What if each .sql contains a DROP TABLE IF EXISTS statement at the start? Something to be carefull if its the program that generated the backup likes to add this tags. What if my website code breaks? This train of what if type

Re: Backup SQL

2006-08-04 Thread Daniel da Veiga
On 8/4/06, Chris White [EMAIL PROTECTED] wrote: On Friday 04 August 2006 10:35 am, Daniel da Veiga wrote: What if each .sql contains a DROP TABLE IF EXISTS statement at the start? Something to be carefull if its the program that generated the backup likes to add this tags. What if my website

RE: Backup SQL

2006-08-04 Thread John Meyer
If you're using Myphpadmin, you can turn this option off when generating the dump file. -Original Message- From: Chris White [mailto:[EMAIL PROTECTED] Sent: Friday, August 04, 2006 12:14 PM To: mysql@lists.mysql.com Subject: Re: Backup SQL On Friday 04 August 2006 10:35 am, Daniel da

Re: Backup SQL

2006-08-04 Thread Chris White
On Friday 04 August 2006 11:26 am, Daniel da Veiga wrote: Think better before you hit send. Dude -- -- Chris White PHP Programmer/DBarn Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]