transfering a mysql dbase

Im switching webhost cause mine has employed a massive amount of idiots that cant seem to do anything right.

I picked out a new host. Problem is they don't offer ssh access. They have phpmyadmin instead.

Im a command-line nerd. So How hard is it going to be to transfer my mysql databases over to the new host? (I have 5)

Is there an equivalant to the mysqldump command in phpmyadmin?

or should I say screw it and find a new host that offers ssh?

If you're unfamiliar with phpMyAdmin and don't want to mess around, just pick the Export option at the top.

If you're used to the usage of cli mysql, you can pretty much do the same thing in phpMyAdmin by clicking on SQL on any given table/db.

you can also use this command if the database is too big to be importted via phpmyadmin:

markupmysql -h<host> -u<user> -p<pass> <database> < <uncompressed db>

That works providing your database is uncompressed.

example:

That would inport the sql file "uploaded_db" into the datebase "babe_db".

Hope that helps.

If your woundering how to run that command if you dont have SSH access, in php you can simply use the system("command"); function.

aaahhhhhhh

Thx Mr. Cheese! That system command should work perectly….

Talk to the host offer web cam at which point you do a lot of 'picking my pencil up off the floor' the transfer will be finished within the hour trust me ;)