Re: Re: phpmyadmin - moving data from one database to another

if your database is more than a couple mb you may not be able to do this - shared hosts limit your max memory per script and max upload size. Use select into outfile like this: SELECT a,b,a+b INTO OUTFILE "/tmp/result.text" FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY "\n" FROM test_table; It will write the data to a delimited file - then upload this file to new server and use LOAD DATA INFILE much the same way SELECT INTO OUTFILE http://www.mysql.com/doc/S/E/SELECT.html LOAD DATA INFILE http://www.mysql.com/doc/L/O/LOAD_DATA.html olinux --- Taylor York <taylor@dreamstargroup.com> wrote: > Just dump the data and structure to an SQL file, > choose save as file, then > run all the code in the file on the next server. > > > Taylor York > > "Phil Schwarzmann" <pschwar@jhmi.edu> wrote in > message > news:sd0f1769.049@cis27.hosts.jhmi.edu... > > The lazy and worthless a-holes at > www.infinitehost.com (my host server) > > are forcing me to move all my MySQL data from one > server to another > > because they are too dumb to fix it. > > > > I need to use phpmyadmin to move the data but i'm > not %100 sure how to > > do it. There are some "view dump" commands. It > looks like I can > > somehow download all the data and structure to my > local computer, then > > upload it to the new server. > > > > Anyone have any info on this? > > > > THanks! > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > __________________________________________________ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com