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. XOOPS Community Support forums / 
  3. Installation Troubleshooting 
  4.  / Problem exporting mySql database
Register
1
rudycash
Problem exporting mySql database

  • 2005/1/29 17:38

  • rudycash

  • Just popping in

  • Posts: 70

  • Since: 2004/2/12


I'm trying to move a site to a new host - the problem is my new host is using a different version of mysql. (a newer version) when I export the database and try and import it to the new one they seem incompatible and I get this error

MySQL said: Documentation
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'contentId` int(10) unsigned NOT NULL auto_increment,
`section


Any ideas on how I can import the database?
2
jdseymour
Re: Problem exporting mySql database

Sorry to answer the question with a question, but I need more information.

What are the versions of MySQL on both servers? How are you exporting/importing (cli, phpmyadmin ect)?
3
rudycash
Re: Problem exporting mySql database

  • 2005/1/29 18:15

  • rudycash

  • Just popping in

  • Posts: 70

  • Since: 2004/2/12


OK

I'm exporting from " phpMyAdmin 2.6.0-pl3


MySQL 4.0.22-standard running on localhost "

and importing on "phpMyAdmin 2.6.1-rc1


MySQL 4.0.23-standard running on localhost"

Thanks for the reply - this has been ruining my afternoon.
4
jdseymour
Re: Problem exporting mySql database

OK that helps some. I just migrated my site to new servers two weeks ago. I had a rough time with the database import with Phpmyadmin also.

Once I got it sorted out I added to this FAQ Page. Just read through that real quick and see if anything there will help you. I am not sure of the size of your database but if it is too large, once you get past your current errors it will timeout.

Anyway HTH.
5
rudycash
Re: Problem exporting mySql database

  • 2005/1/30 10:21

  • rudycash

  • Just popping in

  • Posts: 70

  • Since: 2004/2/12


I still can't get it to work

The problem lies in the diifference between the two versions creating the syntax error.

Quote:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'contentId` int(10) unsigned NOT NULL auto_increment,
`section


Is there any other method of exporting the database?
6
jdseymour
Re: Problem exporting mySql database

Can you use mysqldump?
7
rudycash
Re: Problem exporting mySql database

  • 2005/1/30 10:42

  • rudycash

  • Just popping in

  • Posts: 70

  • Since: 2004/2/12


Er - how do I do that?
8
jdseymour
Re: Problem exporting mySql database

Your host will have to allow access to the command line. You use it through the MySQL CLI. But I am gathering more information through google as we speak. Seem there are some problems with the single quotes in the sql file.

I will post if I find a common denominator before I go to work.
9
Bender
Re: Problem exporting mySql database

  • 2005/1/30 10:56

  • Bender

  • Home away from home

  • Posts: 1899

  • Since: 2003/3/10


For the export you could use the mysqlbackup module.

Go to http://www.nagl.ch
10
rudycash
Re: Problem exporting mySql database

  • 2005/1/30 11:12

  • rudycash

  • Just popping in

  • Posts: 70

  • Since: 2004/2/12


Thanks

I'm ready through lots of msql forums - I really need to work this out.
(1) 2 »

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

195 user(s) are online (142 user(s) are browsing Support Forums)

Members: 0

Guests: 195

more...

Donat-O-Meter

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

Latest GitHub Commits