You can:
1) leave the old DB and create a new one, then change db.ini to match
2) make a copy or zip the directory c:\mysql\data\{your database name}
3) c:\mysql\bin\> mysqldump {database name} > {file name}
I have become a little concerned with 3, I have noticed that \' and \" are output as ' and " that doesn't appear to source back in corectly. Anyone know how to make this work right?
NOTE for #1 If you had to use the grant all priv... thing in mysql to get connected you may need to do it again for this DB
*edit clarified #1
|