Hi 
I'm looking for a way to backup a table on a remote host. The table will not be in use when it is backed up.
Due to problems with not having root access, I am unable to use methods such as dump.
I thought select into outfile would be the best option however, when testing on my local windows setup I kept getting the same problem.
Every time I do the select statement, it always halts @ record 30.
Does anyone know why this is, or can suggest a better option for backing up a table?
The code im using is (and i do change the output file name, so it's not a problem trying to overwrite an existing gile):
select * into outfile "c:/test2.txt" FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY "\n"
FROM hits_live_mas
LOAD DATA INFILE 'c:/test2.txt' INTO TABLE hits_live_mas
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY "\n"
Thank you in advance,
Dibby
I'm looking for a way to backup a table on a remote host. The table will not be in use when it is backed up.
Due to problems with not having root access, I am unable to use methods such as dump.
I thought select into outfile would be the best option however, when testing on my local windows setup I kept getting the same problem.
Every time I do the select statement, it always halts @ record 30.
Does anyone know why this is, or can suggest a better option for backing up a table?
The code im using is (and i do change the output file name, so it's not a problem trying to overwrite an existing gile):
select * into outfile "c:/test2.txt" FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY "\n"
FROM hits_live_mas
LOAD DATA INFILE 'c:/test2.txt' INTO TABLE hits_live_mas
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY "\n"
Thank you in advance,
Dibby