possible but i find a very severe conflict with mysqldump between what the prod server will understand and what the test server will understand.. example: at the bottom of a create table section of mysqldump you will see the line : /*40000 ALTER TABLE! LOCK READ--*/ and of course gives error 10064:syntax error so i usually have to edit/comment out those lines so backup tablename is faster and works better usually...
----- Original Message ----- From: "Riaan Oberholzer" <[EMAIL PROTECTED]> To: "Andy B" <[EMAIL PROTECTED]> Sent: Tuesday, April 13, 2004 2: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. > > > --- Andy B <[EMAIL PROTECTED]> 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 > > test server into say c:/db_backup/db_name, connect > > to my local test server > > and then type: > > restore db_name.tablename from c:/backup/db_name/ > > and have it work.... > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > __________________________________ > Do you Yahoo!? > Yahoo! Small Business $15K Web Design Giveaway > http://promotions.yahoo.com/design_giveaway/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]