Re: Mysql Backup/Dump

2005-06-15 Thread Kishore Jalleda
It is recommended that you upgrade to 4.0.x first from 3.23.xx, because of any changes to the grant tables in the mysql database, make sure you read the upgrade notes before upggrading, here's a good link to upgrade, http://dev.mysql.com/doc/mysql/en/upgrade.html I find it very simple to zip all

Re: Mysql Backup/Dump

2005-06-15 Thread sharif islam
I just moved my databases to 4.1 from 3.23. It went pretty smoothly. First I used mysqldump to back up the data. Then installed 4.1. First thing did was import only the mysql table. Then ran /mysql_fix_privilege_tables command. After that I was able to login to mysql with my old root password.

Mysql Backup/Dump

2005-06-14 Thread Kory Wheatley
I want to backup our entire Mysql database structure for mysql 3.23.58 and dump it in the newly installed mysql 4.1.10 What is the best command to do a backup and dump everything into the new MYSQL version on a different box? __ Do You Yahoo!?

Re: Mysql Backup/Dump

2005-06-14 Thread mfatene
different box, different versions, use export/import (backup table or LOAD DATA) Mathias Selon Kory Wheatley [EMAIL PROTECTED]: I want to backup our entire Mysql database structure for mysql 3.23.58 and dump it in the newly installed mysql 4.1.10 What is the best command to do a backup

Re: Mysql Backup/Dump

2005-06-14 Thread Karam Chand
If you are on Windows then you can use a GUI like SQLyog (www.webyog.com) to do the job. I think it will be the easiest way to do that. Karam --- Kory Wheatley [EMAIL PROTECTED] wrote: I want to backup our entire Mysql database structure for mysql 3.23.58 and dump it in the newly installed