Web Hosting Talk







View Full Version : backing up databases with phpmyadmin


Vormav
03-20-2002, 07:17 PM
Yeah, I know how you're supposed to do this. But it just won't work right. The first problem is that some of the parts of my database are long, and phpmyadmin wordwraps when dumping. Often, this causes problems. I have lots of text with \', \". When those get seperated by the wordwrap, you suddenly get tons of mysql errors all over the place. The other problem is what it adds. I don't know why it does this, but phpmyadmin adds stuff like "\r\n\r\n\r\n" usually when it word wraps, and sometimes in the middle of non-wrapped words. It's making using backups a nightmare. I thought it might just be a problem with my version, so I setup 2.2.3 and tried it there. There's fewer problems now, but still problems. Any idea how to fix it?

EDIT: Oops. Sorry, I clicked on the wrong board.:blush: