Re: backup table/restore table question

2004-04-12 Thread Andy B
:20 AM Subject: Re: backup table/restore table question > I use mysqldump which generates sql for you and it > works like a charm. Eg, > > mysqldump --user=root databasename.table > output.sql > > The output.sql file then has SQL statements to > generate and exact copy. > &g

Re: backup table/restore table question

2004-04-12 Thread Paul DuBois
At 20:23 -0400 4/12/04, Andy B wrote: hi... i have a server where there are 5 tables inside a database. i was wondering if i did the following command from inside a script: backup table dbname.tablename to /home/users/my_dir/ then with a different script gzip/tar them, after gzipped ftp them to my

backup table/restore table question

2004-04-12 Thread Andy B
hi... i have a server where there are 5 tables inside a database. i was wondering if i did the following command from inside a script: backup table dbname.tablename to /home/users/my_dir/ then with a different script gzip/tar them, after gzipped ftp them to my test server into say c:/db_backup/db_