Forums / Install & configuration / Can't import Mysql database

Can't import Mysql database

Author Message

kenneth kvalvik

Monday 31 March 2003 11:59:48 am

Hi all!

I've decided to give ezPublish 3 a go. But I'm having trouble importing the demokernel.sql or the kernel_clean.sql into the database (using phpmyadmin).

I get this errormessage:
SQL-query :

* - * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - * - * - CREATE TABLE ezapprove_items(

id int( 11 ) NOT NULL auto_increment,
workflow_process_id int( 11 ) NOT NULL default '0',
collaboration_id int( 11 ) NOT NULL default '0',
PRIMARY KEY ( id )
) TYPE = MyISAM

MySQL said:

You have an error in your SQL syntax near '---------------------------------------------------------
--
--

CREATE TABLE ez' at line 2

Anyone that can imagine what I'm doing wrong?

Kenneth

John Hoskins

Monday 31 March 2003 6:02:41 pm

Make sure the database is completely empty.
Use the command line. Looks like a phpmyadmin problem is screwing with the file.

kenneth kvalvik

Monday 31 March 2003 10:27:54 pm

Now I only need to solve this little problem: Maximum execution time of 30 seconds exceeded in /home/webjourn/public_html/ezpublish/lib/ezi18n/classes/ezcodepage.php on line 92

But I think I saw something somewhere...

;-)

Thanks a lot!

John Hoskins

Wednesday 02 April 2003 12:00:20 pm

http://ez.no/developer/ez_publish_3/bug_reports/time_out_in_rebuilding_translation_cache/solution_to_timeout_but

short answer - you get a time first time through with non eng-GB language set.