{Shell} Simple SQL Export

[Groby]

Export your DB from Shell.

#!/bin/sh
echo "==============================================================="
echo -e " \033[31m1. Start SQL-Export\033[0m "
echo -e " \033[33mSQL-Export is Running.\033[0m "
echo "==============================================================="

cd /home/script/DB_Backups
mysql -h 127.0.0.1 -u root newproject_db_auth < newproject_db_auth.sql

echo "==============================================================="
echo -e " \033[31m2. SQL-Export.\033[0m "
echo -e " \033[36m DONE\033[0m "
echo "==============================================================="

 

[WorldOfWars]

10 seconds google search but nice.

[Wizatek]

Not sure if its doing what you say.

This is to import, not export

[Groby]

Not sure if its doing what you say. This is to import, not export

Sql data is on root  export it to mysql .

[Wizatek]

That is called importing.

Exporting is when you make a dump from the database to file.

[peter3301]

+1 wiza

If i import my db:

mysql -u root newproject_data < newproject_data.sql
mysql -u root newproject_db < newproject_db.sql
mysql -u root newproject_auth < newproject_auth.sql
mysql -u root newproject_post < newproject_post.sql