Simplest Way To Auto Cron A Mysql Database
I use a php script usually but that does not work for large files.
I have a 130mb mysql database on linux using cPanel.
What is the easiest way to set up say a monthly cron to back this up to the root server?
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Auto Restart Apache On Cron
ive got a fairly beefy server but at the moment its hosting alot of resource intensive sites (unfortunatly i dont currently have a choice on where to run them all) and apache is crashing to the point its taking upto 2 mins to load pages within about 24hours but once restarted is fine again. so im wondering if anyone can suggest a way to automaticly restart apache via a cron job every 24hours or so?
View Replies!
View Related
Mysql Auto Restart
Is anyone experiencing that cpanel automatically restarts mysql at 2AM? I'm curious is that new feature or something has gone wrong? This has started after cpanel upgrade mysql to 5.0.67 version. I'm not so good with cpanel so please can somebody tell me where cpanel holds its crons? I cannot find nothing in /etc/cron.* or in cron -l, and I want to turn this option off.
View Replies!
View Related
Backup MySQL Databases By Cron
how to backup MySQL databases by cron and have the backups sent to you by email, or have them uploaded by FTP. It is based on a script I found at another website though I can confirm it is fully working. Change the commented variables in the following file and save it as backup.sh: Code: #!/bin/sh # This script will backup one or more mySQL databases # and then optionally email them and/or FTP them # This script will create a different backup file for each database by day of the week # i.e. 1-dbname1.sql.gz for database=dbname1 on Monday (day=1) # This is a trick so that you never have more than 7 days worth of backups on your FTP server. # as the weeks rotate, the files from the same day of the prev week are overwritten. #/bin/sh /home/user/directory/scriptname.sh > /dev/null ############################################################ #===> site-specific variables - customize for your site # List all of the MySQL databases that you want to backup in here, # each seperated by a space # If not run by root, only one db per script instance databases="mydbname" # Directory where you want the backup files to be placed backupdir=/home/mydomain/backups # MySQL dump command, use the full path name here mysqldumpcmd=/usr/bin/mysqldump # MySQL Username and password userpassword=" --user=myuser --password=mypasswd" # MySQL dump options dumpoptions=" --quick --add-drop-table --add-locks --extended-insert --lock-tables" # Unix Commands gzip=/bin/gzip uuencode=/usr/bin/uuencode mail=/bin/mail # Send Backup? Would you like the backup emailed to you? # Set to "y" if you do sendbackup="n" subject="mySQL Backup" mailto="me@mydomain.com" #===> site-specific variables for FTP ftpbackup="y" ftpserver="myftpserver.com" ftpuser="myftpuser" ftppasswd="myftppasswd" # If you are keeping the backups in a subdir to your FTP root ftpdir="forums" #===> END site-specific variables - customize for your site ############################################################ # Get the Day of the Week (0-6) # This allows to save one backup for each day of the week # Just alter the date command if you want to use a timestamp DOW=`date +%w` # Create our backup directory if not already there mkdir -p ${backupdir} if [ ! -d ${backupdir} ] then echo "Not a directory: ${backupdir}" exit 1 fi # Dump all of our databases echo "Dumping MySQL Databases" for database in $databases do $mysqldumpcmd $userpassword $dumpoptions $database > ${backupdir}/${DOW}-${database}.sql done # Compress all of our backup files echo "Compressing Dump Files" for database in $databases do rm -f ${backupdir}/${DOW}-${database}.sql.gz $gzip ${backupdir}/${DOW}-${database}.sql done # Send the backups via email if [ $sendbackup = "y" ] then for database in $databases do $uuencode ${backupdir}/${DOW}-${database}.sql.gz > ${backupdir}/${database}.sql.gz.uu $mail -s "$subject : $database" $mailto < ${backupdir}/${DOW}-${database}.sql.gz.uu done fi # FTP it to the off-site server echo "FTP file to $ftpserver FTP server" if [ $ftpbackup = "y" ] then for database in $databases do echo "==> ${backupdir}/${DOW}-${database}.sql.gz" ftp -n $ftpserver <<EOF user $ftpuser $ftppasswd bin prompt cd $ftpdir lcd ${backupdir} put ${DOW}-${database}.sql.gz quit EOF done fi # And we're done ls -l ${backupdir} echo "Dump Complete!" exit Upload backup.sh to your server, to any directory you want. A directory which is not web-accessible will stop your login information being seen by just anyone . You should chmod the file to 777: Code: chmod 777 backup.sh If you uploaded this file from a Windows machine you will need to convert the file to Unix format. You should run the following command by SSH in the appropriate directory: Code: dos2unix backup.sh If you don't have dos2unix installed, you can install it using yum if you have that: Code: yum install dos2unix If you don't have yum, get it here. You may want to test the script at this point to make sure it's doing what you want it to. Change to the appropriate directory and run this command: Code: ./backup.sh Once you're happy with it, enter it into the crontab to run daily (or whenever you want). Cron jobs vary a lot depending on the configuration of your system, so check Google for how to do it on your system. The command you will need to run by cron is: Code: /path/to/file/backup.sh
View Replies!
View Related
Reloading A Mysql Database
My server admin linked me to this: [url] I'm using a cpanel based server, but I can't get this to work. It requires I be in a directory I figure (this step isnt included) so I type cd /home/username/public_html/ And then i follow the commands. but it doesnt work. Basically i need to take a mysql database that I uploaded to my directory, and load it back into a database. :@
View Replies!
View Related
Get Mysql Database From Shell
I have a problem getting mysql to start, so I am planning to setup a new server and move all the mysql databases to a new server. The problem is I normally get mysql databases when mysql is running by using mysql command lines. Now that I cannot start mysql, I cannot use that method. Is there a mysql directory that contains all the mysql databases for me to tar it up and untar it on a different? If there is a directory that contains all the mysql databases, do I need to exclude some files/folders so it doesnt conflict with the files/folders on my new mysql server?
View Replies!
View Related
MySQL With Huge Database
ways to improve the database performance in the situation when I have to modify a large table (several million rows), by e.g. adding a column. Currently this would take several hours which is too slow. The bottleneck is disk I/O. I am considering either partitioning the table over several innodb files on several disks, or going to a RAID-5 or RAID-10, it this will give me better write performance. The database is 130GB large, and the problem table (which I make period changes to) is the largest table on the server. I cannot have downtime of 3 hours each time I make a change and adding blank fields (to be used later, when a new field is needed) is not an option. Each time I add a column, the cpu goes into high (80%) io wait state for about 3 hours. I have a hack which would allow me to split the large table into multiple smaller tables based on some criteria (for example, forumID or such). Here are a couple of things but would like to know which is best, and am open to new ideas. The ideas so far: 1. Split the table into 3 or 5 smaller tables each on it's own disk. The disk IO would then not be so bad, and it might only take 1 hour to perform the table change. But this might not work because the changes to the database (as in adding a column) might be serial, meaning only 1 disk is being written to at a time. (Then again, maybe it will work if I launch 3 different scripts, one to update each table at once). 2. Do RAID 5 or 10, and have 3 or 5 disks. This again might not help at all because of the above issue with MySQL writing serially. I am using latest MySQL 5.0.45 with InnoDB engine on Debian etch Linux
View Replies!
View Related
Host Recommendation (Req: PHP5, MySQL, CRON, Mass-Email)
any hosts that can provide the following: PHP5.3 + MySQL CRON (to run daily/weekly scripts at a certain time) Mass Email. The scripts will send emails to a number of users(between 10-100 at first, but may grow) and this will be done daily and weekly. In the past, I've tended to go with SupaNames or FastHosts but looking at their solutions for this, it's not quite right for my requirements.
View Replies!
View Related
How To Secure Access To MySQL Database
What can I do to secure access to my MySQL database to stop it from getting compromised from hackers? Is there any way I can restrict access to the MySQL database to my IP only? The database is for an IPB 2.3.4 forum and the username/password are stored in a conf_global.php file that is CHMODed 0444.
View Replies!
View Related
Big Mysql Database 4gb
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 Replies!
View Related
Managed Database Hosting (Mysql)
if there are any recommendations on managed database hosting services. This will be used for a fairly large project running on Mysql DB. Due to the size and complexity of the database a lot of resources are being used, so I prefer to find a company which specializes in dB hosting.
View Replies!
View Related
[mySQL] Copy Colomn From 1 Database To Another
I'm trying to copy the contents of a column from 1 database to another. I need to do this as the contents in the current database have got messed up after an upgrade. The DB structure table forum_msgs It contains a column called "topic_id". Basically I need to copy over the topic ID fields from the "old" database into the "current" database into table forum_msg replacing any values that are currently in the column "topic_id" I tried this but it doesn't seem to work correctly. Any ideas how it should be done? insert current.forum_msgs ( topic_id ) select topic_id from old.forum_msgs
View Replies!
View Related
Alterntive Way For Downloading A MySQL Database
A friend of mine has an account with a hosting company that recently became unstable and he wants to move his site away. I downloaded the files, but it now seems impossible to download the databases in the conventional ways. I tried downloading them using their control panel (vDeck) but I get an error "File Permissions do not allow to download backup". Then I tried to export it using PHPMyAdmin but the files either doesn't download at all, or it downloads inccomplete with the last lines having something like the following: Cannot modify header information - headers already sent by (output started at /usr/local/apache/htdocs/phpMyAdmin-2.6.3/export.php:121 I tried to contact their support but they have no clue. Is there any way to download the database? I thought of creating a script that would manually itterate through the tables and create an export fie similar to what phpMyAdmin creates. I don't know if this is possible, and I hope there are better ways.
View Replies!
View Related
MySQL Cannot Connect To Database Via PHP
I got this weird problem with my VPS which has MySQL 4.1.22 running on it. Everything works fine for sometime and then out of a sudden, it stop recognizing the mysql users and refused to allow my PHP scripts to access the database. It seems that I needed to restart mySQL server to resolve the issue. Then out of the blues, the same problem occurs. I am running Cpanel on a VPS and there isn't any overloading as the database access is pretty light on my 512mb VPS. I contacted my web host about the issue and it seems like all they do is to restart the mySQL. This cannot be a solution as it happens at least once or twice a day depending on how soon I could catch the problem. All the time this problem occurs, the MYSQL Server is still active and working. I can even access it through PHPMyAdmin but not through the scripts. I just added an hourly crontab so as to restart the MySQL server as a stop gap.
View Replies!
View Related
Backup BIG MySQL Database
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 Replies!
View Related
Exporting Mysql Database From Helm
i have a fren who wants to transfer a hosting ..for a site made in php and hosted in helm...windows server... the site uses mysql datbase but i could see no database in the database setting(of helm)...and says no database created.. in host i could see server.mysql in php database config files i want to export database...to linux server i have not used helm much.. where actually is database located and how can it be exported?
View Replies!
View Related
Fetch Admin Password From MySQL Database
I have forgot the admin password for one of our application. All the users and passwords are stored in database table "users", is there any way I can get the password from the database.. any MySQL query that will fetch the admin password from that database table.
View Replies!
View Related
Apache: Load Vhosts From MySQL Database
if it was possible to load vhosts from a MySQL database and the only solutions i found didnt work for me. Im running Apache on Windows. Has anyone seen anything that would work with Windows? The only alternative i can think of is to read the database info using PHP and output it to a vhosts config file. I dont want to do that though because it means restarting the server to load the new config and i hear that a lot of vhosts slows the server down
View Replies!
View Related
Mysql Database Dump (150mb) Utf8
recently I had problems with backing up my ~150mb database through PHP. And I know some people are backing their databases to a dump file through terminal. My database contains UTF-8 and other characters. I have tried simply dumping with mysqldump but I doesn't seem to work, when restoring all the characters are messed up. Is there any command to tell that the database is UTF-8?
View Replies!
View Related
MySQL Database Service Stops From Running
I have a phpBB forum, which uses MySQl database. For the last two months the forum has been going down every couple of days because the database service has been continuously stoped running on the server with no reason. What can cause such a frequent database failures? Can someone attack the forum/database/server in a way that will cause the above problem? (there is a good reason I consider this possibility very seriously) How can I prevent futher database failures?
View Replies!
View Related
Copying (MySQL) Database Without Panel Access.
A customer would like to move his hosting from another host to me. But the other host does not want to cooperate and give me access to the panel or files. Threw the customer I did get the ftp information, and within the config file I have the database username and password. How is it possible to copy the database, without having the hosting panel access?
View Replies!
View Related
Trying To Import Mysql Database Via CLI In Ubuntu Linux
I have ubuntu 6 server version running. I am trying to import a database I have however I cannot get it working for the last 2 hours! I have tried various commands like logging into mysql entering the "use" command to use a database and then variations of the "source" command but my db.sql file doesn't run. Also tried the full command mysql -uroot -pMYPASS MYDBNAME < /var/www/site/db.sql Neither seem to do anything. PHPMYADMIN shows no database tables at all. Running mySQL 5.
View Replies!
View Related
Do Exchange Auto-responders Reply To Auto-responders
I have an address that receives hundreds and hundreds of e-mails a day. It's an address people aren't supposed to use (basically noreply@mydomain.com), but people do. I'd like to stop being the guy that gets these and routes them as appropriate, but we can't just turn it off and cause a hard bounce, because that will bewilder too many people who don't get that replying to noreply@mydomain.com is a bad idea. (Our website sends out notifications to people. A lot of people reply for various strange reasons, and we also get a lot of autoresponders sending us junk.) I'm a Linux admin, so I'm a bit out of my league -- this needs to be configured on our Exchange box. What I'd really like is an auto-responder for this address that will tell people that they e-mailed a mailbox that no one uses, and give them directions on how to contact a real person if need be. However, fully half of the e-mails we receive are people's auto-responders. Is an Exchange auto-responder going to reply to their auto-responder? This will completely bewilder people. And if this will auto-respond to auto-responders, is there a cleaner solution here? Again, it's got to be Exchange, but I'm a Postfix guy, so I have very little experience here.
View Replies!
View Related
Copy An Account From Another Server Via WHM - Cannot Copy Mysql Database
In previous thread we made few manual transfer of our domains. We also made some automated migration of few domains/sites using Web Host Manager's Copy an account from another server feature. All the files and other settings were properly transferred from old server to new server, but only the mysql database is not visible on new server. I am unsure if the same got copied to new server.
View Replies!
View Related
MYSQL Error "Could Not Connect To The Database"
Last night i went to install GD on my server(Linux RH) I went through the process /scripts/easyapache and at the end of it gave me this error "...Unable to connect to host: 127.0.0.1......Failed......Unable to connect to host: 127.0.0.1......Fail ed......Unable to connect to host: 127.0.0.1......Failed......Unable to connect to host: 127.0.0.1..... .Failed......Unable to connect to host: 127.0.0.1......Failed......Unable to connect to host: 127.0.0.1 ......Failed......Unable to connect to host: 127.0.0.1......Failed......Unable to connect to host: 127. 0.0.1......Failed......Unable to connect to host: 127.0.0.1......Failed......Unable to connect to host: 127.0.0.1......Failed......Unable to connect to host: 127.0.0.1......Failed......Unable to connect to host: 127.0.0.1......Failed......Unable to connect to host: 127.0.0.1......Failed... The was no content, the test may be unable to connect to 8080 simply because tomcat is still initila izing. You can try to go to http://localhost:8080/ to manually check it. -- End test 'Basic tomcat port running test' -- Post check of 'httpd' process Ok -- End post apache restart tests -- Executing '/scripts/initfpsuexec' Executing '/scripts/initsslhttpd' Executing '/scripts/gentomcatlist2' Compiling report... Sending report (336 bytes)... If you want to create a support ticket with cPanel regarding this please reference 'BuildAP Report Id': '528932' Report processed. You can change how PHP is configured. As root, simply execute: /usr/local/cpanel/bin/rebuild_phpconf --help for more information. Build Complete Verbose logfile is at '/usr/local/cpanel/logs/easy/apache/build.1198389830' Now I am unable to connect to MYSQL databases, MYSQL is still running from what I can see. I have base knowlage of Linux as well.
View Replies!
View Related
How To Merge A Database Into A New Empty Database
How to merge a database into a new empty database? I used this method and its not working mysqldump --opt -uusername -p databasename > databasename.sql mysqldump --opt -uusername -p databasename < databasename.sql but get this error /*!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 */; /*!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 */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
View Replies!
View Related
|
TRACKER
