Revision history of "MYSQL DATABASE BACKUP"

Jump to navigation Jump to search

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

  • curprev 14:26, 7 October 2025‎ Bacchas talk contribs‎ 1,576 bytes +1,576‎ Created page with "==Mysql Backup and Restore == ===List Databases=== '''Login to server ''' mysql ''' List databases''' show databases; '''List Tables in a database''' use databasename show tables; ===Bakcup a single database=== <pre> done from bash - no need to log in to mysql mysqldump -u root -ppassword sugarcrm > sugarcrm.sq syntax mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql </pre> ===Backup a single table=== <pre> mysqldump -u root -ppassword dat..."
Retrieved from "https://www.r512.com/index.php/MYSQL_DATABASE_BACKUP"