[FIXED] How can I access the MySQL command line with XAMPP for Windows?

Issue

How can I access the MySQL command line with XAMPP for Windows?

Solution

Your MySQL binaries should be somewhere under your XAMPP folder. Look for a /bin folder, and you'll find the mysql.exe client around. Let's assume it is in c:\xampp\mysql\bin, then you should fireup a command prompt in this folder.

That means, fire up "cmd", and type:

cd c:\xampp\mysql\bin
mysql.exe -u root --password

If you want to use mysqldump.exe, you should also find it there.

Log into your mysql server, and start typing your commands.

Hope it helps...

Answered By - Wadih M.

Answer Checked By - Cary Denson (PHPFixing Admin)

Read More

[FIXED] Mysql ERROR: ASCII '\0' while importing sql file on linux server

Issue

I am getting following error while importing sql file

ERROR: ASCII '\0' appeared in the statement, but this is not allowed unless option --binary-mode is enabled and mysql is run in non-interactive mode. 
Set --binary-mode to 1 if ASCII '\0' is expected. Query: ''.

HELP NEEDED...!!

Solution

Try something like :

mysql -u root -p -h localhost -D database --binary-mode -o < dump.sql

and make sure your sql file is not zipped.

Answered By - Eric BELLION

Read More

[FIXED] -bash: mysqldump: command not found MAC OS X

Issue

I want to export and import a .sql file from MySQL server from to my machine with a command line:

/Applications/MAMP/Library/bin/mysqldump -P 3306 -h server  -u login  -p passwd  database  > db_backup.sql

But I get this error:

-bash: /Applications/MAMP/Library/bin/mysqldump: No such file or directory

Solution

It work well now, I just changed:

/Applications/MAMP/Library/bin/mysqldump

by:

/Applications/MySQLWorkbench.app/Contents/MacOS/mysqldump  

Answered By - Errabbah Tarik

Read More