SQL problem

«

Previous topic

|

Install & configuration

|

Next topic

»

Author	Message
Steph A	Thursday 17 March 2005 7:59:15 am I am moving to a new provider. But I cant insert my existing database into the new one. I get error code #1064 when trying with both phpadmin and MySQL administrator. Can anyone help?
Łukasz Serwatka	Thursday 17 March 2005 10:12:18 pm Hi, What versions of MySQL do you use? If you move from 4.1.x to 4.0.xx use --compatible=mysql40 for mysqldump. This is parse error. You can try manualy fix this in dump file, of course if is small enought ;) Personal website -> http://serwatka.net Blog (about eZ Publish) -> http://serwatka.net/blog
Steph A	Friday 18 March 2005 2:13:50 am CREATE TABLE `ezapprove_items` ( `collaboration_id` int( 11 ) NOT NULL default '0', `id` int( 11 ) NOT NULL AUTO_INCREMENT , `workflow_process_id` int( 11 ) NOT NULL default '0', PRIMARY KEY ( `id` ) ) ENGINE = MYISAM DEFAULT CHARSET = latin1 COLLATE = latin1_danish_ci AUTO_INCREMENT =1 This is the error I get. I also get a error when trying to use command "compatible=mysql40" in shell, errorcode #1064. What is wrong?
Łukasz Serwatka	Monday 21 March 2005 5:09:15 am Hi, If you uses MySQL 4.1.x try mysqldump --compatible=mysql40 --default-character-set=latin1 -u root -p database_name > dump.sql Set your encoding for --default-character-set Personal website -> http://serwatka.net Blog (about eZ Publish) -> http://serwatka.net/blog

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing:	Jan 31 2025 03:28:52
Script start
Timing:	Jan 31 2025 03:28:52
Module start 'layout'
Timing:	Jan 31 2025 03:28:52
Module start 'content'
Timing:	Jan 31 2025 03:28:52
Module end 'content'
Timing:	Jan 31 2025 03:28:52
Script end

Main resources:

Total runtime	0.0308 sec
Peak memory usage	8,192.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0054	588.1250	151.2109
Module start 'layout'	0.0054	0.0033	739.3359	220.6875
Module start 'content'	0.0087	0.0200	960.0234	997.9141
Module end 'content'	0.0287	0.0021	1,957.9375	33.9922
Script end	0.0308		1,991.9297

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0029	9.4629	14	0.0002
Check MTime	0.0011	3.4312	14	0.0001
Mysql Total
Database connection	0.0009	2.9775	1	0.0009
Mysqli_queries	0.0023	7.4531	3	0.0008
Looping result	0.0000	0.0325	1	0.0000
Template Total	0.0014	4.5	1	0.0014
Template load	0.0011	3.4970	1	0.0011
Template processing	0.0003	0.9646	1	0.0003
Override
Cache load	0.0007	2.3381	1	0.0007
General
dbfile	0.0002	0.7711	8	0.0000
String conversion	0.0000	0.0201	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs