import .sql file

jfontein

Hello,

Sorry, but I am pretty new into MySQL and stuff.

I exported a file via phpMyAdmin from my hosted server and am trying to import it into my Server and MySQL that I installed locally on my PC (using XAMPP).

Now I can get into the databases that were installed as demo when installing XAMPP, via phpMyAdmin.

I want to import the whole database I exported and is saved in file: D:\WWW\DAP-Basic\SQL\DAP_Basic.sql

In phpMyAdmin, I just go to a random database (cdol), click the "SQL" tab and than type the following line in the textbox with the header "Run SQL query/queries on database cdcol: "

shell> mysqlimport db_name D:\WWW\DAP-Basic\SQL\DAP_Basic.sql

This returns the following error:
#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 'shell> mysqlimport db_name D:\WWW\DAP-Basic\SQL\DAP_Basic.sql' at line 1

What should I do?? Include something like username and password of the server or something???? Can I refer to "D:\WWW..."

Please explain in dummy language!!

Thanks,
Joost

superwormy

'shell> mysqlimport ...' is definitally NOT an SQL command.

You need to run SQL INSERTs, which is what is inside of your .sql file. Copy/paste the contents of the SQL file into the box, and click 'Go' or whatever.

Alternatively, phpMyAdmin also has a 'Run SQL commands from a file...' option or something on the bottom of some of the pages ( maybe on the SQL tab as well ) which allows you to upload a .sql file and execute the SQL INSERT commands inside of it.

jfontein

Thanx. That worked!!

Now the next issue:
I am trying to FTP my files from my harddisk to the server I installed on my PC.
In XAMPP Control I turned on FileZillaFTP
Then in my WS_FTP LE, I try to transfer my files, using 127.0.0.1 and userid = newuser and password = wampp, just as XAMPP is describing.

It returns that connection was refused. I wonder if it is wrong username and password or something else.
I wouldn't even know where I could define username and password for the FTP server...

Any help on this??

superwormy

Wait... you're trying to FTP files from your computer's hard drive... to the FTP server installed on... your computer?

Why are you trying to FTP a file from your computer back to your computer... its already on your computer, just copy and paste the file whereever you want it to be...