Problems moving the forum database to another server (databse backup)

[carlatf]

Hi People,

I've been forced to do an OS reinstall because I had an IRCmalicius bot running.
I have the older disk mounted in a secondary drive and I also have a webmin backup of my site.

When I tried to restore the webmin backup it didn't worked. I opened the tar.gz file and there it was the database.

I restore all the smf files now my problem is how to restore the database. It's here when I need help because I have no experience doing this.

My question is: Can I directly  move the database that I was using (not the backup) in the other server to my new server with some mysql command?. 
How I can find the smf database in the other server? I only found my backups when i did a "locate mysqldatabasename.sql".
http://www.simplemachines.org/community/index.php?topic=157614.0


I read  that I can simply import the database to mysql with a command but I also read in another post that you had to create the tables before doing that. I thought that when I imported the database all the data was imported...


Many thanks to the mysql gurus for reading!.

[Sarge]

My question is: Can I directly  move the database that I was using (not the backup) in the other server to my new server with some mysql command?. 

I'm not a MySQL guru, but you probably can solve the problem by simply copying the database files over to the new installation.

If the old tables were using the MyISAM engine (not InnoDB), the database folder for the forum should contain .frm, .MYD and .MYI files for each table. For example:

smf_sessions.frm
smf_sessions.MYD
smf_sessions.MYI

smf_settings.frm
smf_settings.MYD
smf_settings.MYI

etc.

Simply copy them over.

[carlatf]

Many thanks. I didn't found the frm files but I moved the .sql databases with the command explained in the guide. The only problem was that I had 10 databases and I didn't know how to do it in batch so I had to do it 10 times.

Many thanks for your help.