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

"Please Note:
  • At the specific request of Ibexa we are changing this projects name to "Exponential" or "Exponential (CMS)" effective as of August, 11th 2025.
  • This project is not associated with the original eZ Publish software or its original developer, eZ Systems or Ibexa".

Can't import Mysql database

Author Message

kenneth kvalvik

Monday 31 March 2003 11:59:48 am

Hi all!

I've decided to give Exponential 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/Exponential/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.