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
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 (
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
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 anoth
4 matches
Mail list logo
