Dumping a MySQL datavase with php
Posted on 2006-07-09
I'm looking for a way to move a MySQL database from one web derver to another.
Through a Google search I found MySQL Dump Class. It looks like it might work, but the example (as follows) is TOTALLY confusing. I want to save the dumped database to a file that I can ftp to my local machine & upload to a new host.
This "example" script seems like it "prints" the dump? Why on earth do that? Also, there is no reference to "mydb". What is that?
mysql_connect("localhost", "root", "");
$dump = new MySQLDump();
Can someone help me understand this example script or point me to another way? I want to dump the MySQL database to a file. I ONLY have ftp access & the current web host is uncooperative. I DO NO have general command line access at the server so I don't think I can use MySQL Dump.