dump all the data to csv and read it in the other end!
Phil Schwarzmann [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
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
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)
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 [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
The lazy and worthless a-holes at www.infinitehost.com (my
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
4 matches
Mail list logo