WHMCS-bridge

  Categories

1
ADFS
 1
Azure AD PowerShell Script
 1
Azure AD Services
 4
Backup/Restore
 13
Computer
 35
cPanel - Control Panel
 33
CPanel/WHM/Reseller
 5
Database MSSQL
 11
Databases
 6
DNS - Nameserver
 10
Domain Management
 11
Email
 6
Exchange Server
 9
FTP
 1
Hyper V
 7
Installing a Control Panel
 1
Linux
 8
Mail Filters & SPAM
 11
Mobile
 1
MS SQL
 3
Others
 15
Powershell Scripts
 10
Security
 60
SiteWorx (Control Panel)
 79
Softaculous
 19
SolusVM
 13
SSL
 1
Ubuntu/Centos/Linux
 3
Virus
 5
VMware
 33
Windows Server
 18
WordPress

  Categories

  Tag Cloud

How do I Connect to a Database using SQL Server Management Studi Database Connection using SQL Server Management Studio? DNS Export/Import How to export and import DNS how to export/import the DNS Windows Process Activation Service – Error 13: The data is inval WordPress Installation in Cpanel/Whm WordPress installation in Cpanel cpanel wordpress installation No connectivity with any of Web Conferencing Edge Servers. No connectivity with any of Web Conferencing Edge Servers. Exter Verify all Web Conferencing Edge Services in the topology are ru and network connectivity is available. PowerShell – Updating Users Email Addresses In Active Directory Updating Users Email Addresses In Active Directory Add/Change/Remove Primary SMTP and Alias smtp in Active Director Add Primary SMTP and Alias smtp in Active Directory Remove Primary SMTP and Alias smtp in Active Directory reconfiguration is not possible Failed at 98% : Unable to find the system volume Failed at 98% : Unable to find the system volume reconfiguration Vmware 98 % failed on system volume Lync Migration to Office 365 Lync Migration from Onpremises to Office 365 Users and Move Disabled users to OU Remove Group from the Disabled Script to delete the file older than 2 days Windows Deployment Services (WDS) PXE Boot Issue Windows PXE Boot Issues This may cause the connection to the WDS server to terminate pre Get a List of Installed Application from computers (PowerShell) Powershell Script list of installed application How to connect Remote Connection Machine connect remote connection how to check database name with size database size database name with size Computer keyboard shortcut keys keyborad shortcut keyboard shortcut key computer Laptop Microsoft Windows shortcut keys list windows shortcut keys ms word shortcut key Word shortcut keys MS Word shortcut keys Excel shortcut keys MS Excel shortcut keys Outlook shortcut keys MS Outlook shortcut keys Windows Key Shortcuts WINKEY shortcuts shortcut keys for special characters Windows System Commands Firefox Keyboard Shortcuts Shortcuts for Mac Finder Shortcuts Chrome Keyboard Shortcuts Email configuration Cpanel email configuration mail configuration DNS error while adding a Parked domain in WHM Script to Add Members in the Azure AD group Undo-SoftDeletedUnifiedGroup Ubuntu SSL Apache Centos SSL Apache How to Fix "A Required Device Isn't Connected or Can't Be Access how to run manual cpanel/whm backup How to force Manually cPanel/WHM to run a backup How to move WHM MySQL data directory how to the stop the config firewall scrolling How To Enable php shell_exec In cPanel Enable exec() with PHP-FPM Enabling PHP-FPM (PHP FastCGI Process Manager) in cPanel/WHM aut 227 entering passive mode ftp connect connection timed out How to Install Imagick on cPanel Server Setting the PHP Max Execution Time on cPanel How To Install Zend OPCache on cPanel Servers Restart on Task Hang Force Non Legacy Backup to Start (WHM/cPanel) Resizing/Expanding tmp Partition RPM database corrupted SQL SERVER – Login Failed. The Login is From an Untrusted Domain Login Failed. The Login is From an Untrusted Domain and Cannot b Why is “Application permissions” disabled in Azure AD's “Request application permissions" is grayed out Export Azure App Service Certificate & Upload to Azure App Servi SSL certificate App service SSL certificate How to Generate a CSR for Microsoft IIS 8 IIS8 CSR Generation in IIS8 How to Generate a CSR for Amazon EC2 (AWS) How to Generate a CSR for Apache Web Server Using OpenSSL How to Generate a CSR for Plesk 10 Bulk upload to Azure Cosmos using C# How to Open Ports for Passive FTP in CSF Passive FTP in CSF (Configserver Firewall & Security) this could be due to credssp encryption oracle remediation CredSSP Encryption Oracle Remediation Create the .well-known folder in IIS well-known/pki-validation hidden directory using Microsoft IIS M Resize your Linux root '/' mount with LVM how to increease dev/mapper/ubuntu--vg-ubuntu--l

  Support

  My Support Tickets   Announcements   Knowledgebase   Downloads   Network Status   Open Ticket

How to move WHM MySQL data directory Print

  • How to move WHM MySQL data directory
  • 0

Additionally, please always create a full mysqldump before ever doing something like this as well as stopping Service Manager > MySQL monitor option, since that will restart MySQL after you've stopped it and while you are moving it. The better steps are these:

1. Make a full mysqldump file:

Code:
mysqldump --all-databases | gzip > /home/alldatabases.sql.gz

2. Uncheck monitor in WHM > Service Manager for Mysql and save the area

3. Stop MySQL

Code:
/etc/init.d/mysql stop

4. Make the directory for MySQL in /home, move it and symlink it:

Code:
mkdir /home/var_mysql
mv /var/lib/mysql /home/var_mysql
chown -R mysql:mysql /home/var_mysql/mysql
ln -s /home/var_mysql/mysql /var/lib/mysql
/etc/init.d/mysql start

5. Re-check monitor in WHM > Service Manager for MySQL and save the area

If anything goes wrong, you have the full mysqldump backup, and can use these steps to restore from it:

First, you'll need the MySQL root password:

Code:
cat /root/.my.cnf

Once you have the password, then you can use this command to restore from that file:

Code:
gunzip < /home/alldatabases.sql.gz | mysql -u root -p

You'll be asked for the password here, so simply enter the one noted in /root/.my.cnf location.

Was this answer helpful?

Related Articles

How to update your cPanel Contact Information or receive a notification on reaching quota limit? If you want to receive notification on reaching your disk quota, bandwidth usage limit, reaching... How to Change cPanel Style/Theme? Switching over to another cPanel theme with a different style is easy and there are two ways to... How to Edit file in the cPanel File Manager? 1. Log into your cPanel account.2. In the "Files" section, click on "File Manger" Icon. 3.... How to Change Language of your cPanel? cPanel supports a lot of languages, and if you want to change your cPanel language to your native... How to Reset my cPanel Account Password? If you can access your cPanel account, follow these steps to reset your password:1. Log into your...
« Back

  Tag Cloud

How do I Connect to a Database using SQL Server Management Studi Database Connection using SQL Server Management Studio? DNS Export/Import How to export and import DNS how to export/import the DNS Windows Process Activation Service – Error 13: The data is inval WordPress Installation in Cpanel/Whm WordPress installation in Cpanel cpanel wordpress installation No connectivity with any of Web Conferencing Edge Servers. No connectivity with any of Web Conferencing Edge Servers. Exter Verify all Web Conferencing Edge Services in the topology are ru and network connectivity is available. PowerShell – Updating Users Email Addresses In Active Directory Updating Users Email Addresses In Active Directory Add/Change/Remove Primary SMTP and Alias smtp in Active Director Add Primary SMTP and Alias smtp in Active Directory Remove Primary SMTP and Alias smtp in Active Directory reconfiguration is not possible Failed at 98% : Unable to find the system volume Failed at 98% : Unable to find the system volume reconfiguration Vmware 98 % failed on system volume Lync Migration to Office 365 Lync Migration from Onpremises to Office 365 Users and Move Disabled users to OU Remove Group from the Disabled Script to delete the file older than 2 days Windows Deployment Services (WDS) PXE Boot Issue Windows PXE Boot Issues This may cause the connection to the WDS server to terminate pre Get a List of Installed Application from computers (PowerShell) Powershell Script list of installed application How to connect Remote Connection Machine connect remote connection how to check database name with size database size database name with size Computer keyboard shortcut keys keyborad shortcut keyboard shortcut key computer Laptop Microsoft Windows shortcut keys list windows shortcut keys ms word shortcut key Word shortcut keys MS Word shortcut keys Excel shortcut keys MS Excel shortcut keys Outlook shortcut keys MS Outlook shortcut keys Windows Key Shortcuts WINKEY shortcuts shortcut keys for special characters Windows System Commands Firefox Keyboard Shortcuts Shortcuts for Mac Finder Shortcuts Chrome Keyboard Shortcuts Email configuration Cpanel email configuration mail configuration DNS error while adding a Parked domain in WHM Script to Add Members in the Azure AD group Undo-SoftDeletedUnifiedGroup Ubuntu SSL Apache Centos SSL Apache How to Fix "A Required Device Isn't Connected or Can't Be Access how to run manual cpanel/whm backup How to force Manually cPanel/WHM to run a backup How to move WHM MySQL data directory how to the stop the config firewall scrolling How To Enable php shell_exec In cPanel Enable exec() with PHP-FPM Enabling PHP-FPM (PHP FastCGI Process Manager) in cPanel/WHM aut 227 entering passive mode ftp connect connection timed out How to Install Imagick on cPanel Server Setting the PHP Max Execution Time on cPanel How To Install Zend OPCache on cPanel Servers Restart on Task Hang Force Non Legacy Backup to Start (WHM/cPanel) Resizing/Expanding tmp Partition RPM database corrupted SQL SERVER – Login Failed. The Login is From an Untrusted Domain Login Failed. The Login is From an Untrusted Domain and Cannot b Why is “Application permissions” disabled in Azure AD's “Request application permissions" is grayed out Export Azure App Service Certificate & Upload to Azure App Servi SSL certificate App service SSL certificate How to Generate a CSR for Microsoft IIS 8 IIS8 CSR Generation in IIS8 How to Generate a CSR for Amazon EC2 (AWS) How to Generate a CSR for Apache Web Server Using OpenSSL How to Generate a CSR for Plesk 10 Bulk upload to Azure Cosmos using C# How to Open Ports for Passive FTP in CSF Passive FTP in CSF (Configserver Firewall & Security) this could be due to credssp encryption oracle remediation CredSSP Encryption Oracle Remediation Create the .well-known folder in IIS well-known/pki-validation hidden directory using Microsoft IIS M Resize your Linux root '/' mount with LVM how to increease dev/mapper/ubuntu--vg-ubuntu--l

  Support

  My Support Tickets   Announcements   Knowledgebase   Downloads   Network Status   Open Ticket

WordPress and WHMCS integration by i-Plugins