On Saturday 23 December 2006 10:00, [EMAIL PROTECTED] wrote:
> I'm looking at migrating MySQL 3.x server to new machine running MySQL 4.x;
> at this time I aim to dump one by one user databases and insert data into
> MySQL 4.x,
>
> if there are any MySQL experts here, any comments please ?

mysqldump -uroot -psecret --all-databases >/tmp/`date +%b%d`.sql
then restore and you can fix any problems that occur

James
-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html

Reply via email to