Import mysql DB with XAMPP in command LINE

Question

I have this command   mysql -u  myusername -p  mypasswd MYBASE  lt  c  user folderss myscript sql   But I get the following error   Error unknow command   U  unknow command   m  unknow command   D  unknow command   L

User · Answer

Do your trouble shooting in controlled steps:

(1) Does the script looks ok?

DOS E:\trials\SoTrials\SoDbTrials\MySQLScripts
type ansi.sql
show databases

(2) Can you connect to your database (even without specified the host)?

DOS E:\trials\SoTrials\SoDbTrials\MySQLScripts
mysql -u root -p mysql
Enter password: ********
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.0.51b-community-nt MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

(3) Can you source the script? (Hoping for more/better error info)

mysql> source ansi.sql
+--------------------+
| Database           |
+--------------------+
| information_schema |
| ...                |
| test               |
+--------------------+
7 rows in set (0.01 sec)
mysql> quit
Bye

(4) Why does it (still not) work?

DOS E:\trials\SoTrials\SoDbTrials\MySQLScripts
mysql -u root -p mysql < ansi.sql
Enter password: ********
Database
information_schema
...
test

I suspected that the encoding of the script could be the culprit, but I got syntax errors for UTF8 or UTF16 encoded files:

ERROR 1064 (42000) at line 1: 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 '´++
show databases' at line 1

This could be a version thing; so I think you should make sure of the encoding of your script.

User · Answer

this command posted by Daniel works like charm  C  xampp mysql bin gt mysql -u  DB USER  -p  DB NAME   lt  path to file ab sql   just put the db username and db name without those backets    NOTE  Make sure your database file is reside inside the htdocs folder  else u ll get an Access denied error

User · Answer

Copy Database Dump File at  Windows PC  D  xampp mysql bin  mysql -h localhost -u root Databasename  lt  data11 sql

User · Answer

mysql -h localhost -u username databasename  lt  dump sql   It works  try it  If password is blank no need to add the -p args

User · Answer

I think the OP s problem was not escaping the slashes   on windows a path like   c  user folderss myscript sql  should in the command line be written like either     c    user   folders   myscript sql   or    c  user folders myscript sql   therefore   u  from  c  user  was interpreted as a command   see  http   dev mysql com doc refman 5 5 en mysql-commands html for more info

User · Answer

Go to the xampp shell command line  and run  mysql -h localhost -u username databasename  lt  dump sql

User · Answer

here is my try to import database from cmd in xampp server  the correct command for me is this you can change it with your requirements and i also attached Errors that i face first time importing db from command line you can see last command that i use and i paste it here also its working fro me   mysql -h localhost -u root ovxsolut windhs  lt  C  Users eee Downloads ovxsolut windhs sql

User · Answer

C  xampp mysql bin gt mysql -u  DB USER  -p  DB NAME   lt  path to file filename sql mysql -u root -p dbname lt   quot C  Users sdkca Desktop mydb sql quot

User · Answer

The process is simple-    Move the database to the desired folder e g   xampp mysql folder   Open cmd and navigate to the above location Use command to import the db -  mysql -u root -p dbpassword newDbName  lt  dbtoimport sql  Check for the tables for verification

User · Answer

You may also need to specify the host  From your statement  it looks like you run on Windows  Try this   mysql -h localhost -u  myusername -p  mypasswd MYBASE        lt  c  user folderss myscript sql   Or  mysql -h localhost -u  myusername -p  mypasswd MYBASE         lt   c  user folderss myscript sql

User · Answer

mysql -h localhost -u username -p databasename  lt  dump sql

User · Answer

For those using a Windows OS  I was able to import a large mysqldump file into my local XAMPP installation using this command in cmd exe   C  xampp mysql bin gt mysql -u  DB USER  -p  DB NAME   lt  path to file ab sql   Also  I just wrote a more detailed answer to another question on MySQL imports  if this is what you re after

User · Answer

No Doubt It does the trick   C  xampp mysql bin gt mysql -u  DB USER  -p  DB NAME   lt  path to file ab sql   But some time you many find  MySql Server has Gone a way   For that you need to change mysql bin my ini  max allowed packet   64M to my ini

User · Answer

It works   mysql -u root -p db name  lt   C  folder name db name sql    C   is for example

User · Answer

opt lampp bin   mysql -u dbusername -p dbname  lt  sqlfilepath sql

User · Answer

In Windows  place the MySQL file  i e  example sql  in C  xampp mysql bin   Open the XAMPP Control Panel  and launch Shell   cd c  xampp mysql bin mysql --default-character-set utf8 -h localhost -u username databasename  lt  example sql      Note  Using --default-character-set utf8 can help to prevent encoding issues with special characters if you intend on working with UTF-8    Afterwards  remove the MySQL file from C  xampp mysql bin

User · Answer

I think the commands are OK  issue is with the spaces  Please observe the spaces between -u and  myusername also between -p and  mypasswd   mysql -u  myusername -p  mypasswd MYBASE  lt  c  user folderss myscript sql   Can also be written as   mysql -u myusername -p mypasswd MYBASE  lt  c  user folderss myscript sql   Also  you need not add -p and the time of command  if your password is blank  it will not ask you for the password  If you have password to your database  it will ask for the password   Thanks

[mysql] Import mysql DB with XAMPP in command LINE

Examples related to mysql

Examples related to import

Examples related to xampp