Tag: mysql

login to mysql to see what databases are there. mysql -u root -p mysql> show databases; +———————-+ | Database | +———————-+ | information_schema | | DatabaseXY | | DatabaseXYZ | | mysql | | phpmyadmin | +———————-+ 7 rows in […]

this is the way you can export/backup and import/restore a single/all databases: backup and restore a single database (one by one): mysqldump -u root –password=mysql-root-password database_name > dumpfilename.sql restore: (you will need to find out the password for the mysql-root […]

linus torvalds hates backups, he like everyone else, tends to not do them. but if you feel your multiple wordpress installations should be backed up, in case some russian spam-hacker manages to completely compromise your site(s). you can install this […]