Page 1 of 1

query maker

Posted: Wed Oct 05, 2005 1:47 am
by sebs
Do you know a possibility to make the query file(.sql) directly from access,MSSQL or MYSQL?I ask you because I have a very big database and I can't make it manually the insert and to make a program that does that takes time because I have over 25 columns in the database

Posted: Wed Oct 05, 2005 4:02 am
by malcolmboston
it is built into phpmyadmin -> export

Re: query maker

Posted: Wed Oct 05, 2005 4:38 am
by n00b Saibot
sebs wrote:to make a program that does that takes time because I have over 25 columns in the database
would take only 5-7 minutes....

Posted: Wed Oct 05, 2005 6:52 am
by sebs
Yes I made that and it creates a .sql file with latin1 caracter set and the server I tryed to upload it on give s an error.Do you know how to make a .sql file with utf8 caracter set.I also tryed with mysqldump and it makes the same even with the set caracter=utf8 option.Do you understand?

Posted: Wed Oct 05, 2005 7:33 am
by feyd
I would hazard to guess the dump output stuff like

Code: Select all

DEFAULT CHARSET=blah AUTO_INCREMENT=60
try removing those. The import's typically don't like those two settings.

Posted: Wed Oct 05, 2005 8:42 am
by sebs
What is this error because I cn't find anything about it?
#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 'DEFAULT CHARSET=utf8' at line 25

Posted: Wed Oct 05, 2005 8:44 am
by feyd
as I suspected.