Forums Register Login

moving your tables+content to another MySql server

+Pie Number of slices to send: Send
Say I have created some tables (call it
myDB) and it is staffed with some info. I want to
send myDB to a different server with mySQL What should I send?

I tried sending the:
Program Files/MySQL/MYSQL server 4.1/ data/myDB
but for some reason not all tables are passed???

does anyone know what is the best way to send your tables+content in mySql to a different computer with mySql?

thanks
Ppr
+Pie Number of slices to send: Send
You could use mysqldump. This dumps the DDL plus the data.
+Pie Number of slices to send: Send
the mysqlsump is a command-line utility. I would like my clients (not computer savvy) to duplicate the db for backup and to send it to me from time to time.

Q: Is there a less command-line more visualize way to do it?
thanks
+Pie Number of slices to send: Send
The first thing that comes into my head is use the cron (or windows task scheduler etc.) to run the dump utility, then just get them to send you the output from wherever you tell it to put it.
[ March 08, 2005: Message edited by: Horatio Westock ]
+Pie Number of slices to send: Send
I realized that the tables are located at
C:\Program Files\MySQL\MySQL Server 4.1\data

(first thing I did is to zip myDB and unzip it at the other end, but it doesnt work - it does work with MS Access)

so say I have a table name: myDB, how can I export it and how can the other side Import it?

does anyone have any java code that runs the mySqlDump utility?
Ppr
Oh. Hi guys! Look at this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 862 times.
Similar Threads
how to connect servlet with mssql
how to create sequence in mysql
Jboss 7 Datasource configured correctly...But unable to connect
how to connect with mssql
'export' & 'import' database tables and content in MySql
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 19:33:30.