Transferring MySQL database from one area to another, is it possible?

[Cjmax]

I have switched from Xenonservers to Elpishost and was wondering if I could copy/switch over the MySQL database from the Xenonserver to the new one. Is this possible? Any idea how to do it? Thanks!

[lorde banana]

Export the SQL database via something like HeidiSQL

[Svenskunganka]

Run a mysqldump (You might have to contact Xenon for that):

mysqldump -u root -p password dbname > db.sql

If you have access to phpMyAdmin you can just export the database and then import it to the new server.

[Cjmax]

Okay, so I have exported the database "information_schema" and now have information_schema.sql downloaded. Anyone here know how to get that information into an Elpishost server? I don't see any slq database related items anywhere on the control panel. Thanks again.

[Svenskunganka]

[QUOTE=Cjmax;42525702]Okay, so I have exported the database "information_schema" and now have information_schema.sql downloaded. Anyone here know how to get that information into an Elpishost server? I don't see any slq database related items anywhere on the control panel. Thanks again.[/QUOTE]

Why would you export the "information_schema" database? It's a default database that all MySQL servers use.

[Cjmax]

I don't know, probably because I don't have a fucking clue as to what I am doing. I'm going to see what I can find about the sqldump.

[editline] eheeh [/editline]

Welp, turns out I was looking for sv.db and not anything within MySQL. Being an idiot is awesome! Thanks to those who helped.

[Svenskunganka]

[QUOTE=Cjmax;42527472]I don't know, probably because I don't have a fucking clue as to what I am doing. I'm going to see what I can find about the sqldump.

[editline] eheeh [/editline]

Welp, turns out I was looking for sv.db and not anything within MySQL. Being an idiot is awesome! Thanks to those who helped.[/QUOTE]

I see. Mark thread as solved please.