|
|
Joined: Aug 2004
Posts: 490 Likes: 2
Addict
|
|
Addict
Joined: Aug 2004
Posts: 490 Likes: 2 |
Hmm, apparently I just need to put the name of a given table right after the database name, will give it a shot.
Just have a question about a possible problem using MySQL 4.0.22. The manual states that before version 4.1.2 "out of range numeric valuessuch as -inf and inf, as well as NaN (not a number)values are dumped by mysqldump as Null. The significance of this behavor is that if you dump and restore the table, the new table has contents that differ from its original contents."
Would this affect a forum backup?
|
|
|
|
|
Joined: Jul 2006
Posts: 2,143
Pooh-Bah
|
|
Pooh-Bah
Joined: Jul 2006
Posts: 2,143 |
I have never run into a problem with that. Not sure if Rick has.
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Nope, nothing I've ever ran into either.
|
|
|
|
|
Joined: Jun 2006
Posts: 16,532 Likes: 150
|
|
Joined: Jun 2006
Posts: 16,532 Likes: 150 |
Nope, nothing I've ever ran into either. Ditto, and I've been using the command line sqldump command since MySQL3 (all the way up to MySQL5)
|
|
|
|
|
Joined: Aug 2004
Posts: 490 Likes: 2
Addict
|
|
Addict
Joined: Aug 2004
Posts: 490 Likes: 2 |
Guys, about downloading a forum backup (mysql dump), every time I'm practically done downloading the file my ftp program shows this dumb message about a file like that already existing, with the usual "skip", "overwrite", etc. options popping up.
Why does this happen? The file was never downloaded previously...
|
|
|
|
|
Joined: Jun 2006
Posts: 16,532 Likes: 150
|
|
Joined: Jun 2006
Posts: 16,532 Likes: 150 |
Possibly it timed out when downloading and the download tries to restart and wants to know if you want to continue the download (either by overwriting the old file, or some clients allow you to resume the download)
|
|
|
|
|
Joined: Aug 2004
Posts: 490 Likes: 2
Addict
|
|
Addict
Joined: Aug 2004
Posts: 490 Likes: 2 |
There seem to be no interruptions, and I've tried like a dozen times. Everytime, and even using 3 different ftp programs, it still comes up with the usual skip/overwrite/etc. stuff even though the file is being downloaded for the very first time.
|
|
|
|
|
Joined: Jun 2006
Posts: 16,532 Likes: 150
|
|
Joined: Jun 2006
Posts: 16,532 Likes: 150 |
Do your clients let you read the raw messages? One of them should say whats happening when the download starts.
|
|
|
|
|
Joined: Aug 2006
Posts: 1,659 Likes: 1
Pooh-Bah
|
|
Pooh-Bah
Joined: Aug 2006
Posts: 1,659 Likes: 1 |
Have you tried temporarily renaming the download file?
|
|
|
|
0 members (),
253
guests, and
121
robots. |
|
Key:
Admin,
Global Mod,
Mod
|
|
|
|