Moving MySQL database from UniServer to Ubuntu Server?
The simplest option is to just back up everything in the filesystem and carry it over.

To find out where your data is, look at the datadir variable with in mysql

test&gt; show variables like 'datadir';
+---------------+-------------------+
| Variable_name | Value             |
+---------------+-------------------+
| datadir       | /var/lib/mysql/   |
+---------------+-------------------+
1 row in set (0.00 sec)


Note Your actual value may differ.

Then from your shell shut down mysql, back it up and copy it over.  Something like:

&gt; sudo service mysql shutdown
&gt; cd /var/lib/mysql
&gt; sudo tar -czf /path/with/enough/space/db.tgz *


Copy your db.tgz over to your new server and uncompress it on your new servers datadir while it is shutdown