4/11/2024 0 Comments Download website hostgator cpanel![]() To use rsync, requires setting up ssh on both ends, as rsync uses ssh for connections.įor the above process to work, you’ll have to setup ssh, which may require working a ticket with them, if you’re new to this process.Īlso… sigh… GoDaddy is great as a Registrant (domain registration). ![]() If you really do use MySQL, your mileage will likely vary (process will likely fail if the version mismatch covers many major versions).įor most HostGator accounts, you have ssh available. I use this same process when moving all client sites between LXD containers on different machines, when a machine requires a major OS upgrade… so I’ve done this process 100s of times now.Īs long as you use MariaDB as your target (new hosting), this process works well. Note: Always use MariaDB, not MySQL, because MySQL’s code quality has become so bad.Ĭode quality is so bad that Debian/Ubuntu/Derivatives now install MariaDB when for MySQL packaging targets. Then on new hosting, service start mysql, which may take a while if there’s a large version mismatch between mysql on both old + new hosting. Since mysql is stopped on both servers, data will be consistent. Rsync old hosting to old hosting /var/lib/mysql to new hosting. Rsync old to new /etc/mysql/* (Ubuntu/Debian) + ~/.my.cnf (RedHat/CentOS) which pulls root credentials for database access… as root…Īt this point /var/lib/mysql on new hosting will be mainly correct + still unusable, because data is inconsistent. Rsync old hosting to new hosting /var/lib/mysql which pulls data. Here’s how I do this when I take on new hosting clients with many databases.Īlso rm -rf /var/lib/mysql + mkdir /var/lib/mysql + chown mysql:mysql /var/lib/mysql Moving many databases can be time consuming.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |