| ||
If you've got a very large database.gz file, it's often easier to upload first, and restore in a seperate step. 1) Once you've got the gz file uploaded onto your server, login to ssh and cd to the path where the file is located.
cd /path/to/your/gz/file
2) The next step is to extract the gz file into it's raw sql form (text). To do that, use the gunzip program, eg:
/usr/bin/gunzip < database.gz database.sql
This should have extracted the gz file into the sql in plain text form.3) Before you can load the sql file into mysql, you'll need to ensure you have the database and database user created. Go to User Level -> MySQL Management, and create the empty database normally through DA. 4) To restore the sql to mysql, run the following command:
mysql -udbusername -ppassword username_dbname < database.sql
where you'd replace the bold entries with the applicable values.This could can be combined into a more simple pipe form to offer fewer steps, but this method has the benefit of being able to show you any errors at each step to ensure everything is as it should be. |
- Hosting
- _Web Hosting Services
- __Linux Web Hosting
- __Windows Hosting
- __Reseller Hosting
- _Dedicated Server Hosting
- __VPS Hosting
- __Cloud Hosting
- _App Hosting
- __Wordpress Hosting
- __Magento Hosting
- __Crystal Report Hosting
- Domain
- _Buy Cheap Domain Names
- __General TLDs
- __Country Code TLDs
- _Domain Transfer
- _PKNIC Cards
- Digital Marketing
- _Social Media Marketting
- __Twitter Ads
- __Facebook Ads
- __LinkedIn Ads
- __Google Ads
- __Youtube
- __Google Business
- _Seo Services
- __On Page Seo
- __Content Writing Services
- _Search Engine Marketing
- __Pay Per Click
- _Email Marketing Server
- __G-Suit For Business
- Design
- _Website Design
- __Wordpress Website Design
- __PSD to HTML Services
- __PSD to Wordpress Services
- _Business Design
- __Logo Design
- __Business Stationary Design
- Development
- _Website Development
- __Wordpress development
- __OJS Development
- __Ecommerce Website
- __WooCommerce Optimization
- _Mobile App Development
- Add Ons
- _Cheap Licenses
- __Cpanel Licenses
- __Plesk Licenses
- __Cloud Linux Licenses
- _Website Security
- __SSL Certificate
- __Wordpress Security
- _Microsoft Dynamics
- Contact Us
0 Comments