New subject: [xwiki-users] [MySQL] Database Dump 0.9.2

10 Nov 2005

Hi,

I am having such trouble importing the mysql dump 0.9.2 into my mysql
database.

I am working from the installation instructions found at xwiki here:

[http://www.xwiki.org/xwiki/bin/view/AdminGuide/Linux+Tomcat+MySQL]

I have successfully created an xwiki database instance in my mysql database,
created the user and granted the user rights over the xwiki database.

The instructions indicate that next I should Download the xwiki-db .zip file
and use it to import the required data into my xwiki database using the
example command line command as shown.

[Download xwiki-db-x.zip and unzip it. Import the mysql dump into the
'xwiki' database using "mysql -u xwiki -pxwiki xwiki <
xwiki-db-x.txt" from
command prompt]

First problem is that the xwiki-db.0.9.2.zip file contains a .sql file, not
a .txt file. I assume that the instructions have not been updated to reflect
with the new mysql database dump.

Secondly I am unable to import this data into my mysql database. I am
running Suse9.1 and mysql Ver 12.22 Distrib 4.0.18.

I tried the above instruction, to import the dump as:
mysql -u xwiki -pxwiki xwiki < xwiki-db-0.9.2.sql

I get this error
ERROR 1064 at line 21: 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 'DEFAULT CHARSET=latin1' at line 11

I tried to do a mysqlimport but this would obviously never work since "The
base name of the text file must be the name of the table that should be
used."

I get an error
mysqlimport: Error: Table 'xwiki.xwiki' doesn't exist, when using table:
xwiki

I have also tried the mysql control center without much success. It also
complains about the SQL sytnax.

Any assistance would be greatly appreciated.

Many thanks
Moloch.