I'm trying to dump a large database with mysqldump... but it keeps loosing characters... does anyone know what options to set to fix this?
-
yes
mysql> DUMP database or cum onto girls face
Grant all gooch permission to SLUT in CUM
That should work -
-
Losing what characters? How big is the database, it should work fine.Comment
-
it's about 3mb... and I get errors importing it... I look at the file and I have lines half missing and some lines merged together...
Comment
-
-
Did it work alright before?
Did you check the database for corruption before dumping it?Comment
-
I've never heard of this problem before. 3mb should be no problem, one of our databases is over 175mb and it dumps fine.
You might want to consider reading the mysql docs/support forum:
http://www.mysql.com/documentation/index.html"Every normal man must be tempted, at times, to spit on his hands, hoist the black flag, and begin slitting throats."
--H.L. MenckenComment
-
the database works fine... I'm currently using it on a site I'm moving it to another server...
mysqldump works on small databases only...Comment
-
Even if it works fine, did you run a check to make sure nothing is corrupt?Originally posted by GFED
the database works fine... I'm currently using it on a site I'm moving it to another server...
mysqldump works on small databases only...
myisamchk --helpComment
-
how do i install this command?Originally posted by Mr.Fiction
Even if it works fine, did you run a check to make sure nothing is corrupt?
myisamchk --helpComment
-
-
I don't know, it exists on my machines.Originally posted by GFED
how do i install this command?
Where are the server geeks that hang out at GFY? Sometimes this place is overloaded with them.
Paging MySQL experts.Comment
-
-
-
I can't believe that there are no MySQL experts reading GFY right now.Originally posted by GFED
just installed phpmyadmin... it times out...
Comment
-
What version of MySQL are you using?Originally posted by GFED
how do i install this command?
If it's older than 3.23, try this command instead: isamchkComment
-
yes edit it manuallyComment
-
I FINALLY got the shit transferred over... DAMN was that a FUCKING HASSLE...
Luckily, my databases consisted of shitloads of tables instead of just one table with a shitload of entries...
So I was able to export/import sections at a time because phpmyadmin gave me the option of selecting what tables I wanted to export...
Thanks Mr.Fiction and everyone else for your help!
Comment
Comment