|
|
|
|
||||
|
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. |
 |
|
|||||||
| Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
|
Thread Tools |
12-26-2005, 08:23 AM
|
#1 |
|
So Fucking Banned
Industry Role:
Join Date: Apr 2001
Location: N.Y. -Long Island --
Posts: 122,992
|
Mysql Question.....
New Version on one box , older version on other box
Trying to take DB dump from new box and put into old box. Now I will need to upgrade Mysql on older box correct? Seem to be getting errors importing the dump.. |
|
|
|
12-26-2005, 08:39 AM
|
#2 |
|
Confirmed User
Industry Role:
Join Date: Nov 2003
Location: Olongapo City, Philippines
Posts: 4,618
|
The dump should be backwards compatible - there should be no problem importing a dump to an older MySql version. A dump file should just contain data, and create and alter statements - nothing special.
Have you tried a backup and restore, or just the dump file? Restore could screw up, as could directly attaching a newer DB. What errors are you seeing? |
|
|
|
|
12-26-2005, 08:47 AM
|
#3 | |
|
So Fucking Banned
Industry Role:
Join Date: Apr 2001
Location: N.Y. -Long Island --
Posts: 122,992
|
Quote:
dumps are from phpMyadmin error upon import is "No SQL query!" |
|
|
|
|
|
12-26-2005, 08:48 AM
|
#4 |
|
CURATOR
Join Date: Jul 2004
Location: the attic
Posts: 14,572
|
do in phpmyadmin.
__________________
tada! |
|
|
|
|
12-26-2005, 08:50 AM
|
#5 | |
|
So Fucking Banned
Industry Role:
Join Date: Apr 2001
Location: N.Y. -Long Island --
Posts: 122,992
|
Quote:
I am yo  |
|
|
|
|
|
12-26-2005, 08:57 AM
|
#6 | |
|
Confirmed User
Industry Role:
Join Date: Nov 2003
Location: Olongapo City, Philippines
Posts: 4,618
|
Quote:
|
|
|
|
|
|
12-26-2005, 08:57 AM
|
#7 | |
|
Too lazy to set a custom title
Join Date: Jun 2004
Location: Brasil
Posts: 15,778
|
Quote:
__________________
Do you need cheap, fast and reliable porn website hosting? Host Head is the way to go!! Asian Gay Special | Live on MSN - Live Webcam Chat | Live Adult Webcam Performances | MY SWEET BLACKS LIVE ON CAM Pukka Tranny | Tattooed Shemales | She's A He | Menu Porno | Porn Performances | All Chubby MY ICQ# 169833797 |
|
|
|
|
|
12-26-2005, 09:53 AM
|
#8 |
|
Confirmed User
Join Date: Nov 2003
Location: ThatOneProgram.com
Posts: 9,898
|
How big is the DB? Can you do it in steps (like by table/data) until it throws the error?
Example, run a basic INSERT command and see if that works, just create a table or something. If that works try to poulate the table with data. if you don't get the error then move to the next query until it breaks.
__________________
Want to promote SUCCUBUS? Click HERE!!!! | Want to buy SUCCUBUS? Click HERE!!!! Yeah, yeah, you know, That One Program! | Want to trade links with StompBunny.com? Loryn (3:16 PM): I love it, just as long as we keep the bedroom door closed from all ears then we can have throw down hard core sex that makes us money haha fuck it we can have sex on money never did that before |
|
|
|
|
12-26-2005, 10:27 AM
|
#9 |
|
Too lazy to set a custom title
Join Date: Jan 2002
Location: Holland
Posts: 9,870
|
you prob have a field with a timestamp. phpmyadmin has a problem with that.
do the dump and delete all the stuf behind the comma where the timestamp field is and replace it with the term : default. hope this solves your problem.
__________________
Don't let greediness blur your vision | You gotta let some shit slide icq - 441-456-888 |
|
|
|
