Import CSV file
LOAD DATA INFILE "/data.csv"
INTO TABLE alldata
FIELDS TERMINATED BY ",";
#Dump DB data to CSV file
SELECT *
INTO OUTFILE '/tmp/products.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\n'
FROM products
Backing up a complete database
mysqldump -u [username] -p [password] [databasename] > [backupfile.sql]
Backing up a specific table
mysqldump -u [username] -p [password] [databasename] [table1 table2 etc]
Backing up multiple databases
mysqldump -u [username] -p [password] --databases [databasename] > [backupfile.sql]
Restoring a database
mysql -u [username] -p [password] [database_to_restore] < [backupfile.sql]
Setting up foreign keys between two databases.
update albums set artist_id = 3 where id = 6;
Set a Password for Root
SET PASSWORD FOR root@localhost=PASSWORD('secretpassword');
Subscribe to new posts
Processing your application
Please check your inbox and click the link to confirm your subscription
There was an error sending the email