Restore backup mysql to a remote mysql server.
mysql -unameuser -p --default-character-set=utf8 < dbname.sql --host=yourIPmysqlServer
* Please take note you must granted the user before restore the DB.
Subscribe to:
Post Comments (Atom)
About Me
- waxs
- Atomik Fire Power for Demonical Crisis Assembly (D.C.A / Malaysia) As Sahar (Singapore / Malaysia) & Ex - Claw (Malaysia) Ex - Adokhsiny (South Korea)
Labels
- Apache (6)
- Backup (4)
- Centos (2)
- CLI (24)
- Cloud (2)
- Cluster (3)
- Database (1)
- Downgrade (1)
- Drupal (1)
- FreeBSD (26)
- Ftp (1)
- IIS (1)
- Lighttpd (1)
- Linux (15)
- Microsoft (2)
- MSSQL (2)
- Mysql (24)
- Network (2)
- News (62)
- Nginx (1)
- OCS (1)
- Perl (1)
- PHP (3)
- Proftpd (1)
- Replication (1)
- Rsync (2)
- SCVMM 2012 (1)
- Squid (1)
- SSL (1)
- Ubuntu (17)
- Upgrade (5)
- Virtual (1)
- VMware (8)
- Windows (3)
- WMI (1)
- Zenoss (2)
No comments:
Post a Comment