query maker

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
sebs
Forum Commoner
Posts: 97
Joined: Tue Sep 20, 2005 10:13 am

query maker

Post 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
malcolmboston
DevNet Resident
Posts: 1826
Joined: Tue Nov 18, 2003 1:09 pm
Location: Middlesbrough, UK

Post by malcolmboston »

it is built into phpmyadmin -> export
User avatar
n00b Saibot
DevNet Resident
Posts: 1452
Joined: Fri Dec 24, 2004 2:59 am
Location: Lucknow, UP, India
Contact:

Re: query maker

Post 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....
sebs
Forum Commoner
Posts: 97
Joined: Tue Sep 20, 2005 10:13 am

Post 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?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post 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.
sebs
Forum Commoner
Posts: 97
Joined: Tue Sep 20, 2005 10:13 am

Post 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
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

as I suspected.
Post Reply