WampServer

Hi,

have a database problem... Php code allows me to import only 100 characters per row into mysql database. How could I import more characters?

Thanks

For importing large databases its better to use the mysql.exe program


left click wampmanager -> MySQL -> MySQL Console

unless you have changed the root userid's password just hit enter when you get the password challenge.

at the mysql> prompt keying the following

mysql>use your_database_name;

mysql> source c:\My\Folder\containing\the\database\backup\file.sql

and it will run it.

Not sure if that is what I'm looking for.

Problem is that I have php script that imports words/sentences to mysql database from text file. And if sentence is too long, it does not fit to database and is just cut from the middle of sentence. What should I do to avoid this to happen and get full sentences imported?

Just increase the length of the field in the table.

Change that field to varchar(1000). For example

And in you php check the length using len($var) to make sure it's not longer than the field limit

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

Sorry to be such a newbie, but the code is not mine and I don't have really any coding experience. I can make simple changes to the code, but I need quite specific instructions.

So would really appriciate if you could walk me trough how to increase that field in the table/change what field to varchar(1000)? How is that done?

Use phpMyAdmin ( left click wampmanager icon -> phpmyadmin )

Select your database

Select the table you are loading

Find the field that is too short

Increase its size as above