Mysql

Large data

[mabc]

Hi ,

I am trying to do the following and need some help.

I am trying to make a table with a million items in it (x) with various fields (abc)
table Web
#*$!#*$!#*$!#*$!#*$!#*$!#*$!#*$!#*$!#*$!#*$!#*$!
A
A
A
B
B
B
C
C
C

however , mysql does not let me upload the data as it is to big , so i try to use big dump and it came back with the following error : database charset is not Latin.

the data looks like the following :

1google.com
2yahoo.com
3youtube.com
4aol.com
5wikipedia.org

my questions are the following :

1. What does Latin charset look like ?
2. Does mysql allow large datasets or is there another database to use ?

Regards

[tomda]

Charset is the character set used to store data in your database... It is important to set the correct charset when creating your table. Usually there is a charset per default for the database, then individual charset for every single table.

Nowadays, we are more and more using the UTF-8 charset to store data. Then, for your information (since you use dump), I use the following MySQL statement to force MySQL to use the charset you want.

$connect=@mysql_connect("$server","$user","$pass") or die ("Unable to connect server");
$db_select=@mysql_select_db("$database") or die ("Unable to get table");
mysql_query("SET CHARACTER SET utf8"); 
mysql_query("SET NAMES utf8");

Yes, I guess mysql allow large datasets but you need to optimise it for better results (From easy setting - reduce charvar, do not use text, use NULL if possible, etc. - To advanced settings - explain SQL, play with MySQL cache settings, etc.)