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
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....

Yes.


--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

MySQL Users Conference: April 14-16, 2004
http://www.mysql.com/uc2004/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to