I want to paste the following: to create a new table via mysqlcommand line client.

DROP TABLE /!32200 IF EXISTS/ access;
CREATE TABLE /!32300 IF NOT EXISTS/ access (
id_access int(11) NOT NULL auto_increment,
name varchar(255) NOT NULL DEFAULT '' ,
PRIMARY KEY (id_access)
);

Can you please help me, i have more than 100 tables in a file, when i use the batch mode to run the sql file it is failing with error 22

saying unable to open file.

or do i nee to copy the file to a specific folder to run the sql file.

Please help me, i am completely struck.
and also i have downloaded the MYsql administrator, but i don't see anything there to run the sql script.

Thank you very much.

    Hi,

    are you on Windows ? In that case use forward slashes instead of backslashes like e.g.

    source c:/path/to/sql/script.sql;

    I'd recommend to save the script in a directory that doesn't contain whitespaces (the complete full path to the file doesn't contain whitespaces).

    Or install phpMyAdmin and use that to import the data.

    Thomas

      Write a Reply...