Quick mySQL question

programming
1

let’s say I have a mySQL database and want to move it over to another webserver, how do I do this?

thanks

2

I believe you just need to copy the contents of the data folder in the mysql folder.

3

If you use PHPMyAdmin, there’s an export feature :slight_smile:

or you could write an app to automate it quickly… or you could do it by hand(last resort)

4

*Originally posted by njs12345 *
**If you use PHPMyAdmin, there’s an export feature :slight_smile:
**

:beer:

thanks dude, export fearture seems really cool.

5

I believe however when you do an export from phpMyAfmin, that it only exports the tables and data. If I remember correctly you will have to create an empty database schema before you do them import because you need a place to import to.

So, if you are exporting a database called mydb then run the export on the first machine. Then go to the new machine and create a database called mydb. Then run the import.

Also, I this won;t bring over your users, you will need to export those from the mysql database.

6

thank you for that info blind