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 importing database in remote server
Register
1
Burnout-BR
Problem importing database in remote server

  • 2005/6/11 22:46

  • Burnout-BR

  • Just popping in

  • Posts: 34

  • Since: 2004/6/15


When i try to import my XOOPS DB in PHPMyAdmin on a remote server it does this problem:

Quote:
Error
SQL-query:

CREATE TABLE lordem_avatar(

avatar_id mediumint( 8 ) unsigned NOT NULL AUTO_INCREMENT ,
avatar_file varchar( 30 ) collate utf8_general_ci NOT NULL default '',
avatar_name varchar( 100 ) collate utf8_general_ci NOT NULL default '',
avatar_mimetype varchar( 30 ) collate utf8_general_ci NOT NULL default '',
avatar_created int( 10 ) NOT NULL default '0',
avatar_display tinyint( 1 ) unsigned NOT NULL default '0',
avatar_weight smallint( 5 ) unsigned NOT NULL default '0',
avatar_type char( 1 ) collate utf8_general_ci NOT NULL default '',
PRIMARY KEY ( avatar_id ) ,
KEY avatar_type( avatar_type, avatar_display )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 COLLATE = latin1_general_ci


My site is running well in local server, i don't know what to do..
2
jdseymour
Re: Problem importing database in remote server

Just this specific table?
3
Burnout-BR
Re: Problem importing database in remote server

  • 2005/6/11 22:53

  • Burnout-BR

  • Just popping in

  • Posts: 34

  • Since: 2004/6/15


No, with any table, this is the just first table.
4
jdseymour
Re: Problem importing database in remote server

Are you using phpmyadmin for export?

Try these options for export.

Add DROP TABLE

Add IF NOT EXISTS

Enclose table and field names with backquotes

I have now 3 articles on my site that may help you.

1. XOOPS Site Migration

2. Regular Database Backup with Cron(Updated)

3. MySQL Database Restore

HTH.
5
wcrwcr
Re: Problem importing database in remote server

  • 2005/6/11 23:02

  • wcrwcr

  • Home away from home

  • Posts: 1114

  • Since: 2003/12/12


Hi Burnout-br

Nice to see you around

Please can you tell us what XOOPS version are you using?

Thanks and welcome back
6
Burnout-BR
Re: Problem importing database in remote server

  • 2005/6/12 8:08

  • Burnout-BR

  • Just popping in

  • Posts: 34

  • Since: 2004/6/15


Hi Wilson, nice to see you again, i'm using XOOPS 2.0.10, and MySQL MySQL 4.1.11
7
Burnout-BR
Re: Problem importing database in remote server

  • 2005/6/13 6:21

  • Burnout-BR

  • Just popping in

  • Posts: 34

  • Since: 2004/6/15


Well, i tried another time like jdseymour
said and got the same error...

Quote:
MySQL said:

#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 'collate utf8_general_ci NOT NULL default '',
`avatar_name`
8
jdseymour
Re: Problem importing database in remote server

I see you are using MySQL version 4.1.11, Same version in both places?
9
Burnout-BR
Re: Problem importing database in remote server

  • 2005/6/14 0:42

  • Burnout-BR

  • Just popping in

  • Posts: 34

  • Since: 2004/6/15


No, the remote server uses MySQL 4.0.22-standard...
10
jdseymour
Re: Problem importing database in remote server

Use the --compatible=mysql40 command for export with mysqldump.
(1) 2 »

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

376 user(s) are online (321 user(s) are browsing Support Forums)

Members: 0

Guests: 376

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