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]

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, Dani

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 w

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 qu

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 b

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 < ~/dr