Dear Tong,
if you have access to the machine in question as root, try:
mysqldump --all-databases > export_it_all_file.sql
You may have to enter MySQL superuser name and password, so it goes like
this:
mysqldump --all-databases -u superuser -p > export_it_all_file.sql
(enter pw at prompt)
The file mysqldump produces holds all the SQL statements needed for a
batch job, creating all databases with all tables and all data. To
import this on the other machine, try:
mysql -u superuser -p < export_it_all_file.sql
You may want to use PhpMyAdmin (www.phpmyadmin.com) for this. It has a
graphical, browser based interface which does the same as mysqldump.
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355 Berlin
# Tel: +49-30-46307-382 Fax: +49-30-46307-388
----- Original Message -----
From: "Tong Kiat, Chiah" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 03, 2001 12:44 PM
Subject: generate database script from existing table?
Hi
I just took over a mysql database with no documenation. Is there any
tools or anyway I could generate a database/table creation script from
the current database? This is because I need to recreate the database
on another machine and currently I have no way of doing so.
thanks
tk
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php