 | | |||||
Welcome, Guest! Ready to make a name for yourself in the domain business? We welcome both the hobbyist and professional domainer to join the discussion as part of the NamePros community.
Click here to create your profile to start earning reputation for posting, and trader ratings for buying & selling in our free e-marketplace. Build your trader rating with each successful sale. Our system has tracked over 100,000 sales and counting!
Click here to create your profile to start earning reputation for posting, and trader ratings for buying & selling in our free e-marketplace. Build your trader rating with each successful sale. Our system has tracked over 100,000 sales and counting!
| ||||||||
| Programming PHP, Perl, Ruby on Rails, AJAX, HTML, XHTML, CSS, JavaScript, MySQL and any other coding topics. |
 |
 |
| | LinkBack | Thread Tools |
08-07-2006, 08:38 AM
| THREAD STARTER #1 (permalink) |
| NamePros Regular  Join Date: Feb 2006 Location: Montreal, Quebec, Canada
Posts: 324
   | Some differences when using Mysql 4.1.x dump on MySQL 4.0.x First off, you can export from phpmyadmin / mysql 4.1.19 a 4.0 compatible version of the sql dump in Operations -> SQL options -> SQL export compatibility -> MYSQL40 If you can't for some reason, MYSQL 4.1.x adds ENGINE=ISAM for example. The 4.0.x compatible is TYPE=ISAM ... so -- FIND : ENGINE= -- REPLACE WITH: TYPE= 4.1 also adds DEFAULT CHARSET=latin1 for example. I think by just removing DEFAULT it should work, but generally i remove the whole line. -- DELETE: DEFAULT CHARSET=latin1 That's about it. </randomInfo>
Last edited by Noobie; 08-07-2006 at 08:42 AM.
Reason: Spelling
|
|
