WampServer

If i compare my live server handling for making new databases and this commanddriven phpmyadmin..
terrible ....junk..crap
Takes ours to get this wamp working and no informationabout importing databases

Wel it s free so it is only a waste of time
In all these years again and over again the same configuration problems for a local server installation



Edited 4 time(s). Last edit at 01/13/2011 12:32AM by janamdo.

What are you talking about?????

Localhost/phpmyadmin

I'm your browser and you have phpmyadmin which can create DBS unlike on live servers where u need to use a cpanel addin to Crete them

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Hello Martin,

I'am sorry i was frustated to get the WAMP server get working
Atthe moment i fixed the localhost problem ( nothing to see ..how frustrating haha ), but it is working now


Yes i must import a database from my shop via cmd import
All that commando tokens, but there is no other way i think?

no

phpmyadmin can import..


on the main page... type in the db name and press create.


then use the import button along the top to import the SQL.


are you sure you have phpmyadmin working? its not commandline - its all GUI

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

yes i know that phpmyadmin can import , but only small sql files
For my webshop i must import a large database...

there is no limit.

php.ini has a limit set for max upload.

you can chnage these values by left clicking wamp>php>php.ini


Find:
post_max_size = 8M
upload_max_filesize = 2M
max_execution_time = 30
max_input_time = 60
memory_limit = 8M

Change to:
post_max_size = 750M
upload_max_filesize = 750M
max_execution_time = 5000
max_input_time = 5000
memory_limit = 1000M

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]



Edited 1 time(s). Last edit at 01/16/2011 09:22PM by stevenmartin99.

woow that's handy with php.ini !
On my server for the live shop therewas no way to get that the host should chance the php.ini for me, but with wamp its easy.

Thanks..that saves my a lot of work otherwise done with the cmd import by me.

max_execution_time = 5000
-------------------------------------------------------
Fatal error: Maximum execution time of 300 seconds exceeded in C:\wamp\apps\phpmyadmin3.3.9\libraries\dbi\mysqli.dbi.lib.php on line 201

Wel the second time the same error for this
I do have a php script for importing ql files, otherwise i use th ecommand import
I try first the script



Edited 1 time(s). Last edit at 01/16/2011 11:11PM by janamdo.

oops this is a phpmyadmin limit


open c:\wamp\apps\phpmyadmin\config.inc.php

add this line


$cfg ['ExecTimeLimit'] = 0;

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]



Edited 2 time(s). Last edit at 01/17/2011 01:20AM by stevenmartin99.

The import of the sql file in phpmyadmin is hanging..there is no progress anymore in loading

i try to do it with the script :"big dump"
as example
// Database configuration

$db_server = 'localhost';
$db_name = 'tuningcomp_tuning';
$db_username = 'tuningcomp_douma';
$db_password = '197476lc';

-----------------------------------------
I do get a error in WAMP with this script
BigDump: Staggered MySQL Dump Importer v0.32b
Database connection failed due to Access denied for user 'root'@'localhost' (using password: YES)

Edit the database settings in C:/wamp/www/bigdump.php or contact your database provider.

----------------------------------------
i used for WAmp
// Database configuration

$db_server = 'localhost';
$db_name = 'testzerospecshop';
$db_username = 'root';
$db_password = '197476lc';

i use SQLyog ultimate ..problemsolved ..i hope

oh no ...error report
Error occured at:2011-01-17 12:07:22
Line no.:24955
Error Code: 1170 - BLOB/TEXT column 'products_description' used in key specification without a key length

Query:
create table products_description (
products_id int(11) not null auto_increment,
language_id int(11) default '1' not null ,
products_name varchar(200) not null ,
products_description text ,
products_url varchar(255) ,
products_viewed int(5) default '0' ,
shipping_description text ,
extra_value_id1 int(10) unsigned default '0' not null ,
extra_value_id4 int(10) unsigned default '0' not null ,
PRIMARY KEY (products_id, language_id),
KEY products_name (products_name),
KEY products_description (products_description),
KEY products_name_2 (products_name)
)

---------------------------------------------------------------
i look at to handle this in sqlyog (that's why it stopped also with the import via phpmyadmin directly?)

solution: i chanced in teh database: text in varchar(255) ..hopes this will work
products_description varchar(255) latin1_swedish_ci ..............

This is not the right solution ..on my shop..the productdescription is not complete anymore, but now on th e localserver?

I do have a productdecsription on my shop larger than varchar(255) and TEXT is not accepted by sqlyog?
Must i use the blob format ? for the productdescription?

At the end of the import a again a error..probabaly a ' ..no clue to solve this?
Error occured at:2011-01-17 13:44:33
Line no.:1702212
Error Code: 1064 - 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 '<br />
<b>Warning</b>: unlink(/home/jdouma/domains/zerospec.com/public_html/adm' at line 1

Strange enough my shopdatabase accepts large productsdescriptions, but when expoerting they are too big?..it is not fair ..

i amstucked with this : no phpmyadmin tweaks and via php script import webshop sql file ..error in de sql file .. i must go to another forum for mysql ..thanks for here



Edited 5 time(s). Last edit at 01/18/2011 11:19AM by janamdo.

Thanks so much!

Re: outdated phpmyadmin interface new
Posted by: stevenmartin99 (---.b-ras2.blp.dublin.eircom.net)
Date: January 16, 2011 09:20PM

there is no limit.

php.ini has a limit set for max upload.

you can chnage these values by left clicking wamp>php>php.ini


Find:
post_max_size = 8M
upload_max_filesize = 2M
max_execution_time = 30
max_input_time = 60
memory_limit = 8M

Change to:
post_max_size = 750M
upload_max_filesize = 750M
max_execution_time = 5000
max_input_time = 5000
memory_limit = 1000M

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]



Edited 1 time(s). Last edit at 01/16/2011 09:22PM by stevenmartin99.

Options: Reply•Quote•PM•Follow Topic•Report
Re: outdated phpmyadmin interface new
Posted by: janamdo (---.cm-3-4b.dynamic.ziggo.nl)
Date: January 16, 2011 09:34PM

woow that's handy with php.ini !
On my server for the live shop therewas no way to get that the host should chance the php.ini for me, but with wamp its easy.

Thanks..that saves my a lot of work otherwise done with the cmd import by me.

Options: Reply•Quote•PM•Follow Topic•Report
Re: outdated phpmyadmin interface new
Posted by: janamdo (---.cm-3-4b.dynamic.ziggo.nl)
Date: January 16, 2011 10:41PM

max_execution_time = 5000
-------------------------------------------------------
Fatal error: Maximum execution time of 300 seconds exceeded in C:\wamp\apps\phpmyadmin3.3.9\libraries\dbi\mysqli.dbi.lib.php on line 201

Wel the second time the same error for this
I do have a php script for importing ql files, otherwise i use th ecommand import
I try first the script



Edited 1 time(s). Last edit at 01/16/2011 11:11PM by janamdo.

Options: Reply•Quote•PM•Follow Topic•Report
Re: outdated phpmyadmin interface new
Posted by: stevenmartin99 (---.b-ras2.blp.dublin.eircom.net)
Date: January 17, 2011 01:17AM

oops this is a phpmyadmin limit smiling smiley


open c:\wamp\apps\phpmyadmin\config.inc.php

add this line


$cfg ['ExecTimeLimit'] = 0;

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]



Edited 2 time(s). Last edit at 01/17/2011 01:20AM by stevenmartin99.

This totally fixed my problems. Drupal + WAMP = Headache.