Using existing database on a new install

[audiopro]

I am setting up a new dev. machine and need to get an old database into the new installation of MySql. There are two databases showing on the database list 'mysql' and 'test'.

Can I drop the old database (contained in a folder) straight in with the existing databases and get any sense from it?

Is there a config file where all the paths are stored or is this the magic of windows?

Keith

http://www.studiosoft.co.uk

 

[vacunita]

You can use mysqldump (a command line utility), to create a dump of the old database into a file, and then use the dump file to recreate it in the new server instance.

mysqldump databasename --user userid --password > c:\youroutput.sql

then take that file and feed it to the new installation.

More info can be found in the myslqdump entry here:

mysqldump




----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[audiopro]

Thanks for that, I have been using the old set up for over 8 years without problems. My processor cooked itself so I am having to start afresh. I have another old machine which can do the dump so I will give that a go.

Keith

http://www.studiosoft.co.uk

 

[audiopro]

Ah that simple installation promise again!
Why does a simple installation take the untrained many hours?
Do I set it up as a service?
I didn't select that option.
I need command line access so I checked that option.

I have it set up, I can log into the database but I am unable to perform any queries, they all return a -2 row count even on 'SELECT * FROM TABLE'.
Running mysqld.exe opens a DOS window, beeps and then goes away. Is this because an instance is already running.
Is there a utility prog to diagnose errors?
Is there supposed to be a config file?

Keith

http://www.studiosoft.co.uk