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.