XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. General XOOPS.org forums / 
  3. XOOPS.org Members Lounge 
  4.  / problem with mysql different versions
Register
1
irmtfan
problem with mysql different versions

  • 2005/8/1 14:55

  • irmtfan

  • Module Developer

  • Posts: 3419

  • Since: 2003/12/7


im using xampp in local for work on database.so i upgrade my site to 2.2 and now i want import my database from local to my running site but that get me error because MySQL version in local is 4.1.11 and the server is 4.0.22
is there any way for convert database from 4.1.11 to 4.0.22
i just want import my works. any way?
2
Dave_L
Re: problem with mysql different versions

  • 2005/8/1 15:23

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


For MySQL >= 4.1.0, mysqldump has a new option "compatible". According to http://dev.mysql.com/doc/mysql/en/mysqldump.html, you would use it like this:

mysqldump --compatible=mysql40 ...
3
irmtfan
Re: problem with mysql different versions

  • 2005/8/1 16:07

  • irmtfan

  • Module Developer

  • Posts: 3419

  • Since: 2003/12/7


thnaks * 10000 Dave
you save my 20 hours working :kiss:
4
irmtfan
Re: problem with mysql different versions

  • 2005/8/1 16:52

  • irmtfan

  • Module Developer

  • Posts: 3419

  • Since: 2003/12/7


ok after dump database successfully now i have utf-8 problem all fields are messy and i think its because "Collation" in MySQL 4.1+
what do i do now for solve this?
5
Dave_L
Re: problem with mysql different versions

  • 2005/8/1 17:01

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


Try using the --default-character-set option. See the link I posted above for details.

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

466 user(s) are online (50 user(s) are browsing Support Forums)

Members: 0

Guests: 466

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Oct 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits