Export/import database

[freddzor11]

Hello! I had my old database and I clicked at export and then I got a file called "Database.sql" and when I try to import it to my new database the players etc don't comes, just the tables without noting

anyone who knows what's could be wrong?

kind regards,
freddzor11

 

[averatec]

maybe you exported just structure without data

 

[freddzor11]

can you send me a picture how It should looks when you export a DB?

 

[averatec]

I don't use phpmyadmin, I found this picture in google, it can be different from newer version of pma

 

[freddzor11]

BUMP

 

[dominique120]

BUMP

Follow this tutorial
https://kb.mediatemple.net/questions/129/Export+and+import+MySQL+databases#gs

 

[Dragonder]

Here is how i do this: Select your ot's database and press "export" on top. image:

I ALWAYS check if the exported sql file contains the data, you see it easily, and you can check it with your backup too.
Just open it with notepad++ or wordpad or even as txt file and you can see it.

 

[freddzor11]

Follow this tutorial
https://kb.mediatemple.net/questions/129/Export and import MySQL databases#gs

doesn't work
---------EDITED---------
Fixed it

 

[dominique120]

doesn't work
---------EDITED---------
Fixed it

You must select the option that says export tables and data.

 

[freddzor11]

You must select the option that says export tables and data.

I don't got any of thoose options