Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact us.

Post New Thread Reply

Register GFY Rules Calendar
Go Back   GoFuckYourself.com - Adult Webmaster Forum > >
mysqldump keeps fucking up the program! mysqldump keeps fucking up the program!
Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed.

 
Thread Tools
Old 06-17-2003, 06:29 PM   #1
GFED
Confirmed User
 
GFED's Avatar
 
Industry Role:
Join Date: May 2002
Posts: 8,120
mysqldump keeps fucking up the program!
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?
GFED is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 06-17-2003, 06:30 PM   #2
Juicy D. Links
So Fucking Banned
 
Industry Role:
Join Date: Apr 2001
Location: N.Y. -Long Island --
Posts: 122,992
yes

mysql> DUMP database or cum onto girls face
Grant all gooch permission to SLUT in CUM

That should work
Juicy D. Links is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 06-17-2003, 06:36 PM   #3
GFED
Confirmed User
 
GFED's Avatar
 
Industry Role:
Join Date: May 2002
Posts: 8,120
that didn't work! try again!
GFED is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 06-17-2003, 06:38 PM   #4
Mr.Fiction
Confirmed User
 
Join Date: Feb 2002
Location: Free Speech Land
Posts: 9,484
Losing what characters? How big is the database, it should work fine.
Mr.Fiction is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 06-17-2003, 06:40 PM   #5
GFED
Confirmed User
 
GFED's Avatar
 
Industry Role:
Join Date: May 2002
Posts: 8,120
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...
GFED is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 06-17-2003, 06:41 PM   #6
GFED
Confirmed User
 
GFED's Avatar
 
Industry Role:
Join Date: May 2002
Posts: 8,120
i'm transfering the file in ascii
GFED is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 06-17-2003, 06:43 PM   #7
Mr.Fiction
Confirmed User
 
Join Date: Feb 2002
Location: Free Speech Land
Posts: 9,484
Did it work alright before?

Did you check the database for corruption before dumping it?
Mr.Fiction is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 06-17-2003, 06:44 PM   #8
NetRodent
Confirmed User
 
Join Date: Jan 2002
Location: In the walls of your house.
Posts: 3,985
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. Mencken
NetRodent is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 06-17-2003, 06:45 PM   #9
GFED
Confirmed User
 
GFED's Avatar
 
Industry Role:
Join Date: May 2002
Posts: 8,120
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...
GFED is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 06-17-2003, 06:50 PM   #10
Mr.Fiction
Confirmed User
 
Join Date: Feb 2002
Location: Free Speech Land
Posts: 9,484
Quote:
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...
Even if it works fine, did you run a check to make sure nothing is corrupt?

myisamchk --help
Mr.Fiction is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 06-17-2003, 07:18 PM   #11
GFED
Confirmed User
 
GFED's Avatar
 
Industry Role:
Join Date: May 2002
Posts: 8,120
Quote:
Originally posted by Mr.Fiction


Even if it works fine, did you run a check to make sure nothing is corrupt?

myisamchk --help
how do i install this command?
GFED is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 06-17-2003, 07:21 PM   #12
Steve
Confirmed User
 
Join Date: Feb 2001
Location: USA
Posts: 6,894
http://www.phpmyadmin.net/
Steve is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 06-17-2003, 07:22 PM   #13
Mr.Fiction
Confirmed User
 
Join Date: Feb 2002
Location: Free Speech Land
Posts: 9,484
Quote:
Originally posted by GFED


how do i install this command?
I don't know, it exists on my machines.

Where are the server geeks that hang out at GFY? Sometimes this place is overloaded with them.

Paging MySQL experts.
Mr.Fiction is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 06-17-2003, 07:23 PM   #14
Mr.Fiction
Confirmed User
 
Join Date: Feb 2002
Location: Free Speech Land
Posts: 9,484
Quote:
Originally posted by Steve
http://www.phpmyadmin.net/
Useful script.
Mr.Fiction is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 06-17-2003, 07:48 PM   #15
GFED
Confirmed User
 
GFED's Avatar
 
Industry Role:
Join Date: May 2002
Posts: 8,120
just installed phpmyadmin... it times out...
GFED is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 06-17-2003, 07:49 PM   #16
Mr.Fiction
Confirmed User
 
Join Date: Feb 2002
Location: Free Speech Land
Posts: 9,484
Quote:
Originally posted by GFED
just installed phpmyadmin... it times out...
I can't believe that there are no MySQL experts reading GFY right now.
Mr.Fiction is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 06-17-2003, 07:53 PM   #17
Mr.Fiction
Confirmed User
 
Join Date: Feb 2002
Location: Free Speech Land
Posts: 9,484
Quote:
Originally posted by GFED


how do i install this command?
What version of MySQL are you using?

If it's older than 3.23, try this command instead: isamchk
Mr.Fiction is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 06-17-2003, 07:53 PM   #18
foe
Confirmed User
 
Join Date: May 2002
Location: CT
Posts: 5,246
yes edit it manually
foe is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 06-17-2003, 07:58 PM   #19
GFED
Confirmed User
 
GFED's Avatar
 
Industry Role:
Join Date: May 2002
Posts: 8,120
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!
GFED is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Post New Thread Reply
Go Back   GoFuckYourself.com - Adult Webmaster Forum > >
mysqldump keeps fucking up the program! mysqldump keeps fucking up the program!
« Previous Thread | Next Thread »

Bookmarks



Advertising inquiries - marketing at gfy dot com

Contact Admin - Advertise - GFY Rules - Top

©2000-, AI Media Network Inc



Powered by vBulletin
Copyright © 2000- Jelsoft Enterprises Limited.