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

Can't he just dump the db to a file and then load it on the new server? I do that all of the time between my laptop and work. Dump the db into a sql file (choosing data and structure for the dump) Create a new db on the server then run: mysql -u xxx -p xxx -D (database name) < name_of_dump_file On Tue, 18 Jun 2002, BB wrote: > dump all the data to csv and read it in the other end! > > "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! > > > > > > -- ------------------------------------- Now Playing: Simple Minds - All The Things She Said Server Uptime: 189 days www.scottah.com