Re: [RDD] Mysql Backup

[Mike Carroll]

Open a CentOS command line and enter "rdadmin".  Try taking the backup.
Look at the command line window for any SQL error messages.

You might also check /var/log/messages on the workstation where you're
trying the backup, and /var/log/mysqld.log on the MySQL server.  You'll
need superuser to access both of those logs.


On Thu, Apr 12, 2018 at 11:27 AM Cowboy  wrote:

> On Thursday 12 April 2018 01:16:39 pm ija...@jamcorbroadcast.com wrote:
> > It used to make backups on it own but after we loaded more songs in the
> > database It stopped making backups.any suggtions
>
>  Unless you're familiar with command line MySQL, not from me.
>
>  We have I don't even know how many entries in our database,
>  and though it takes 4 or 5 minutes to make a backup, it does.
>
> --
> Cowboy
>
> http://cowboy.cwf1.com
>
> Adore, v.:
> To venerate expectantly.
> -- Ambrose Bierce, "The Devil's Dictionary"
> ___
> Rivendell-dev mailing list
> Rivendell-dev@lists.rivendellaudio.org
> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
>
___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev

Re: [RDD] Mysql Backup

[Cowboy]

On Thursday 12 April 2018 01:16:39 pm ija...@jamcorbroadcast.com wrote:
> It used to make backups on it own but after we loaded more songs in the 
> database It stopped making backups.any suggtions

 Unless you're familiar with command line MySQL, not from me.

 We have I don't even know how many entries in our database,
 and though it takes 4 or 5 minutes to make a backup, it does.

-- 
Cowboy

http://cowboy.cwf1.com

Adore, v.:
To venerate expectantly.
-- Ambrose Bierce, "The Devil's Dictionary"
___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev

[RDD] Mysql Backup

[ijames]

Anyone have any suggestions On Making MYSQL and Music Backups  I have 
bee trying to make a backup of our system. No succes

Yet

I Can get to make a backup on Mysql CLI. I mounted a new drive on the 
machine to sent all the backups to. Would like to get suggestion on whe 
proper script in make the backup.


Or Used Mysql Work bench to log into the Mysql database.
___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev

Re: [RDD] Mysql Backup

[ijames]

Just Tried it and

The error Is Unable to Create Backup. Is the file size of the Database.

On 2018-04-10 14:16, Cowboy wrote:

On Tue, 10 Apr 2018 13:01:42 -0400
ija...@jamcorbroadcast.com wrote:


I have been trying to make backup of database. I have tries different
ways to still no success.


 Open rdadmin
 Click Backup Database
 Give it the filename you'd like.
 Click Save

___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev

Re: [RDD] Mysql Backup

[ijames]

Cowboy

It used to make backups on it own but after we loaded more songs in the 
database It stopped making backups.any suggtions


On 2018-04-10 14:16, Cowboy wrote:

On Tue, 10 Apr 2018 13:01:42 -0400
ija...@jamcorbroadcast.com wrote:


I have been trying to make backup of database. I have tries different
ways to still no success.


 Open rdadmin
 Click Backup Database
 Give it the filename you'd like.
 Click Save

___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev

Re: [RDD] Mysql Backup

[Cowboy]

On Tue, 10 Apr 2018 13:01:42 -0400
ija...@jamcorbroadcast.com wrote:

> I have been trying to make backup of database. I have tries different 
> ways to still no success.

 Open rdadmin
 Click Backup Database
 Give it the filename you'd like.
 Click Save

-- 
Cowboy

Fine words! I wonder where you stole them ?

___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev

[RDD] Mysql Backup

[ijames]

Here is what I have been doing

I have been trying to make backup of database. I have tries different 
ways to still no success.
I have not changes anything in the config Here is what I have don so 
far.
1. I Mounted a hardrive to the Machine Did a Mysquldump to a local 
folder. I have some instruction bit they I am Missing something. Is Not 
making The Backup
2. I Was trying to connect to The Mysql Database. It doe not let me 
Fails to connect. Does Anyone have any documentation or Procedures to 
connect to The Mysql Database. I am Using Original Set up no changes to 
The system.


I am als trying to copy The Entire Var Directory. Thiers The gmd & SMD 
that I don't have right to..
 I am trying to also fighure out wher the Logs are Kept so I can Make a 
back up of those to It a ong process to try to copy one by one in RD Log 
editor.



Thanks
___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev

[RDD] mysql backup

[Tim Camp]

Greetings,

Recently moved our mysql server to a new box,
Running Rivendell 1.72
Problem is I couldn't do a backup of the database from Rivendell,
so I tried to just set up a daily backup with mysqldump, however it errors
out with a erron 24,
seems there is a problem with lock tables, I have doublecheck mysql
permissions on this and root
who is running the cron job has correct permissions, seems to be a problem
with too many open files
as it gets about halfway through the backup and crashes.

I can do a manual backup using mysql-administrator or mysql-workbench with
no problem, but I
really need a automatic solution.

I have found on google a bunch of references to this max files issue, but
don't find that setting in my config files.

Anyone crossed this bridge before?

Cheers


-- 
Tim Camp
Director of Operations/Programming
Dot Com Plus L.L.C.
dba WZEW-FM WNSP-FM
Mobile, Al.
___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev

Re: [RDD] mysql backup

[Todd Baker]

Hi Tim,

 

I seem to remember running into something like this.  The my.cnf file
has an entry - open-files-limit - which I think I bumped up to 8192,

I believe the default is much lower.

 

In my system this is in /etc/mysql, but your OS may put it somewhere
else.

 

I think you have to restart the mysql server for this to take effect.

 

Hope this helps,

 

Todd Baker

 

From: rivendell-dev-boun...@lists.rivendellaudio.org
[mailto:rivendell-dev-boun...@lists.rivendellaudio.org] On Behalf Of Tim
Camp
Sent: Monday, September 12, 2011 10:48 AM
To: User discussion about the Rivendell Radio Automation System
Subject: [RDD] mysql backup

 

Greetings,

 

Recently moved our mysql server to a new box,

Running Rivendell 1.72

Problem is I couldn't do a backup of the database from Rivendell,

so I tried to just set up a daily backup with mysqldump, however it
errors out with a erron 24,

seems there is a problem with lock tables, I have doublecheck mysql
permissions on this and root

who is running the cron job has correct permissions, seems to be a
problem with too many open files

as it gets about halfway through the backup and crashes.

 

I can do a manual backup using mysql-administrator or mysql-workbench
with no problem, but I

really need a automatic solution.

 

I have found on google a bunch of references to this max files issue,
but don't find that setting in my config files.

 

Anyone crossed this bridge before?

 

Cheers




 

-- 
Tim Camp
Director of Operations/Programming
Dot Com Plus L.L.C.
dba WZEW-FM WNSP-FM
Mobile, Al.



___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev

Re: [RDD] mysql backup

[Robert Jeffares]

mysqldump -u root -p Rivendell --lock-tables=false /home/put your login 
name here/backupname.sql

should do the business

took a while to find the problem in the logfile but seems to work every 
time i run it


regards

Robert


On 13/09/2011 02:48, Tim Camp wrote:
 Greetings,

 Recently moved our mysql server to a new box,
 Running Rivendell 1.72
 Problem is I couldn't do a backup of the database from Rivendell,
 so I tried to just set up a daily backup with mysqldump, however it
 errors out with a erron 24,
 seems there is a problem with lock tables, I have doublecheck mysql
 permissions on this and root
 who is running the cron job has correct permissions, seems to be a
 problem with too many open files
 as it gets about halfway through the backup and crashes.

 I can do a manual backup using mysql-administrator or mysql-workbench
 with no problem, but I
 really need a automatic solution.

 I have found on google a bunch of references to this max files issue,
 but don't find that setting in my config files.

 Anyone crossed this bridge before?

 Cheers


 --
 Tim Camp
 Director of Operations/Programming
 Dot Com Plus L.L.C.
 dba WZEW-FM WNSP-FM
 Mobile, Al.




 ___
 Rivendell-dev mailing list
 Rivendell-dev@lists.rivendellaudio.org
 http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev

-- 
Robert Jeffares
Big Valley Radio
Thames New Zealand
___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev