Is it possible to backup Mysql database without using cPanel or Phpmyadmin?
RDO Servers
Well-known member
- Joined
- Apr 3, 2015
- Messages
- 1,027
- Points
- 83
Well, it depends. Do you have direct database access, or are you on a shared account with only cPanel access?
You can always generate Create Statements as a backup
You can always generate Create Statements as a backup
elcidofaguy
Well-known member
- Joined
- Jan 13, 2015
- Messages
- 866
- Points
- 0
Its pretty easy to create a database backup... For example if you are using wordpress or any other CMS then you will find a lot of plugins which can do this for you... For that my preference is to use the - duplicator plugin...
Another way you can do that is to setup a schedule task on your server (but you will need to access cpanel to set that up as a cron job) which dumps the data to a location of your choice i.e. folder on server, dropbox etc... There are various scripts for that which you can find online and adapt for your own use... If you are having problems with setting something like that then I recommend contacting your webhost - as I am sure they will be delighted to help, offer guidance on that matter...
Finally the other approach would be to code it your self i.e. PHP script which connects to your database and dumps the data to a SQL file or format of your choice i.e. CSV, XML etc....
In all cases make sure you consider security aspects to avoid your data being accessible/stolen...
Another way you can do that is to setup a schedule task on your server (but you will need to access cpanel to set that up as a cron job) which dumps the data to a location of your choice i.e. folder on server, dropbox etc... There are various scripts for that which you can find online and adapt for your own use... If you are having problems with setting something like that then I recommend contacting your webhost - as I am sure they will be delighted to help, offer guidance on that matter...
Finally the other approach would be to code it your self i.e. PHP script which connects to your database and dumps the data to a SQL file or format of your choice i.e. CSV, XML etc....
In all cases make sure you consider security aspects to avoid your data being accessible/stolen...
MarcS
Member
- Joined
- Jul 31, 2015
- Messages
- 16
- Points
- 0
When you do not have cPanel and phpMyadmin, the only way you can access the server is to have jailedshell. You can run mysqldump command to take the MySQL backups after having jailedshell access.
mysqldump -u username -p database_name > file-name.sql
Most Web Hosts provide jailedshell on demand.
mysqldump -u username -p database_name > file-name.sql
Most Web Hosts provide jailedshell on demand.
Older Threads
Newer Threads
Latest Threads
Recommended Threads
Similar Threads
Latest Hosting OffersNew Reviews
-
Latest hosting offers
-
Save an incredible 90% off! The Best HostPapa Deal so Far: Unlimited SSL, 50 GB NVMe, 24/7 supportEssentials Hosting provides reliable and affordable web hosting solutions!- cancan
- Updated:
-
Affordable Dedicated Servers - Raspberry Pi & Intel N95 | From €12.90/mo - Unlimited Traffic.Affordable Raspberry Pi & Intel N95 Dedicated Servers with SSD Storage and Unlimited Traffic.- Tinyservers.eu
- Updated:
-
SystemInPlace - Low cost Dual E5 384GB/512GB RAM DEDI. 30% OFF FIRST MONTH! 1gb/2.5gb/5gb/10gbAffordable enterprise grade dedicated servers at a price you can afford.- systeminplace
- Updated:
-
