Backup BIG MySQL Database

Nov 29, 2007

What is the recommended method of backing up big MySQL database of size 2 GB ?

Quote:

# mysqldump gallery > gallery.sql
mysqldump: Got error: 1017: Can't find file: './gallery/10tir_user_group.frm' (errno: 24) when using LOCK TABLES
#

I checked the table, it is fine, but can't do the backup.

Quote:

mysql> check table 10tir_user_group;
+-------------------------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+-------------------------+-------+----------+----------+
| gallery.10tir_user_group | check | status | OK |
+-------------------------+-------+----------+----------+
1 row in set (0.07 sec)

mysql>

View 13 Replies


ADVERTISEMENT

Backup Of MySQL Database To A Remote Server

Jul 9, 2008

I have a 1GB MySQL database (compresses down to 300MB) and would like an automated method of backing it up to a remote server. Both accounts are shared hosting accounts (if it matters, both are running CPanel, no shell access on either).

View 13 Replies View Related

What's The Easy Way To Backup Websites/mysql Database

Jun 12, 2008

Due to LayeredTech price hike, i'm going to cancel my server with LT within two weeks.

Does anyone know an easy way to backup all the domians and mysql database in FreeBSD/DirectAdmin? Is there a built in feature in DirectAdmin that can do that?

View 5 Replies View Related

Plesk 11.x / Linux :: Failed To Execute Backup Of Mysql Database

Feb 19, 2015

My OS is CentOS 5.8.
Plesk is 11.0.9.

Having problems with failed daily domain backups. All databases that have been created by Plesk cannot be backed up, thus backup fails with the following message:

<?xml version="1.0" encoding="UTF-8"?>
<execution-result status="error" log-location="/usr/local/psa/PMM/sessions/2015-02-19-044701.875/migration.result">

[Code]...

View 4 Replies View Related

Plesk 11.x / Linux :: Autoupdate Fails ERROR While Trying To Backup MySQL Database

Jun 16, 2014

why but autoupdate fails. It doesn't give a reason why it cant backup.

For line of log :

START pp11.5.30-bootstrapper-11.5.30-cos5.build115131216.11 installing AT Thu Mar 27 07:43:37 CET 2014

Last lines of log :

===> Upgrading database

Trying to start service mysqld... mysqld (pid 24610) is running...
done
Trying to establish test connection... connected
done
Trying to find psa database... version is 011005030
Version is OK, no need to create psa database.
Trying to backup MySQL database...
ERROR while trying to backup MySQL database
Check the error reason(see log file: /tmp/plesk_11.5.30_installation.log), fix and try again

Trying to start psa...

**** Product prep-install for BASE failed.

***** problem report *****
ERROR while trying to backup MySQL database
Check the error reason(see log file: /tmp/plesk_11.5.30_installation.log), fix and try again
STOP Bootstrapper 11.5.30 prep-install for BASE AT Tue Jun 17 04:04:48 CEST 2014

View 2 Replies View Related

Plesk 11.x / Windows :: Importing MySQL Backup - Unable To Restore Database

Mar 20, 2014

I have Plesk Windows version, when I want import my backup mysql, i see below error:

Error: dbbackup failed: Unable to restore database 'admin_IranDnn'

ERROR 2006 (HY000) at line 1: MySQL server has gone awayClick to expand...

View 7 Replies View Related

Plesk 11.x / Linux :: How To Do MySQL Database Daily Backup Via Scheduled Tasks

Feb 12, 2015

I'm new to Parallels Panel. I use version 11.0.9. I want to backup mysql database daily. First of all, what is the best way for daily database backup in plesk. I'm trying to do this in Scheduled Tasks and I use mysqldump command although I'm not sure.

I chose the time and day first and then I switched on the task. I typed the following command to Command line.

mysqldump -uusername -ppassword databasename | gzip -9 >/httpdocs/mydatabase.sql.gz
or
mysqldump -uusername -ppassword databasename >/httpdocs/mydatabase.sql.gz

This created only a blank file. When I use this without gzip, nothing changes.

1- Is mysqldump right command for database backup?
2- Should I define full path for mysqldump, gzip and database? If so, how can I find out the full path of mysqldump, gzip and my database? Because I can't see their locations in panel.
3- I can't see any error message. There is not any log file in httpdocs folder. Where does the log file exist?
4- It is weird but should the username be "database user" or should I write "root" ?

View 2 Replies View Related

Plesk 11.x / Linux :: CentOS Backup Commands For Website Files And MySQL Database

May 27, 2014

I need a command way of backing up my website files and Mysql databases. I no longer have access to the static ip to access the panel.

View 1 Replies View Related

I Moved Mysql From /var To /backup/mysql, Mysql Is No Longer Working

May 8, 2009

Since my /var partition is full, so I moved /var/lib/mysql to /backup/mysql/.

Seems all the files are copied and I changed my.cnf reboot mysql, but all the web sites using db is not working anymore..

View 4 Replies View Related

How To Backup Database Via Cron

Jul 21, 2008

i need to backup database,that not that much huge a small database,now iam useing cpanel server so iam takeing via phpmyadmin manually,now i need to set cron to take backup at every 12hours and save it on specified path,

View 11 Replies View Related

How To Backup Database (cpanel Server)

Jan 13, 2008

I have a crucial database (mysql).

My server is running cpanel. It has daily backup but it is not enough as it is running a lot of transaction daily.

I would like to run the backup to backup database only every 30 mins using cronjob. How do i do that in crontab. I have root access to the server.

View 4 Replies View Related

Backup For My Database To Move From Hostmonster But I Can’t

Aug 6, 2008

I just want to move from hostmonster to dedicated server

the problem is the database(vbulletin) size about 1 GB

when I try make backup for it through ssh it arraive to 723 MB then stop becuase it have highload on hostmonster system they not allowed more than 20% cpu

I take to them they tell me can’t do any thing I please them make backup but they say we can’t do any thing for you and I’m sure they can log by root and do it with ssh on less than 1 minute

how can I make backup or if there r way to move the database to the new server

2 day ago and I can’t move to the new server

View 13 Replies View Related

Phpmyadmin Large Database Backup

Feb 5, 2007

I have a large database 800MB and the export zip & gzip option does not work on this size database export.

works fine on upto 30MB table sizes, does phpmyadmin not support large table
export/backup using gzip or zip?

If its the case that i should be able to use the zip options then what would i look for to put this problem right?

if its the case large table databases are not supported what could i use instead to backup the database tables with compression (gzip)?

View 1 Replies View Related

Remote Database Backup Service

Jul 27, 2007

I have a tiny MySQL database (10MB) and I'm looking for some remote backup service. Someting that will backup the database and let me recover it if the host is in trouble.

I strongly prefer something simple and fully automated.

View 5 Replies View Related

Big Mysql Database 4gb

May 11, 2008

i been trying to move my server.. But mysql database is quite big and restoring takes ages 10 12 hours.. is there anyway i can make it quick because database dump takes 10 15mins but restore takes 12hours and it should be a way to make that quick

View 14 Replies View Related

CPanel Automated Backup Is NOT Backuping One Big Database

May 2, 2008

i recently find out that I don;t have an database backup for one of my biggest websites.

The database I'm talking about has 228 tables (198.6 MB)

In the backup file I only get this :

-- MySQL dump 10.11
--
-- Host: localhost Database: lxxxxxxa_sXXXl
-- ------------------------------------------------------
-- Server version5.0.45-community-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

The other databases I have tried are all ok, but none is this big. Is there any size limit ?

I have uploaded an printscreen with the setings of my WHM.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved