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
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_fil
2 matches
Mail list logo
