Init script fails.

2016-10-02 Thread Michael Munger
TLDR = /etc/init.d/mysql start fails after the following line (line 22), and I would like to fix it so that init starts mysqld automatically. Problem line: |./lib/lsb/init-functions| This is included in nearly all init scripts, and other init scripts work just fine. Putting breadcrumbs in

Re: Long time for client to connect; not for script.

2014-11-11 Thread Hartmut Holzgraefe
On 10.11.2014 17:57, Ken D'Ambrosio wrote: Can someone help explain something to me? When I use mysql to connect to my server, it can take upwards of 15 seconds. Are you connecting to a database with many tables? In that case mysql -A ... (--no-auto-rehash) may make a difference. This will

Long time for client to connect; not for script.

2014-11-10 Thread Ken D'Ambrosio
suspicion would be a reverse DNS resolution issue -- which I can't easily check from the DB host -- but wouldn't that affect both script and client the same?) Thanks! -Ken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Script for cleaning data on a regular basis

2012-03-06 Thread a bv
I found some scripts but i have to edit them to give the true table name to drop. Its format is name1_name2_yearmonth    which year and month here we are talking about is the year and date before the current day . So how can i give this variable to the script? Regards 2012/1/27 walter harms wha

Re: logrotate script doesn't create a new log file

2012-02-23 Thread Honza Horak
On 02/22/2012 07:58 PM, Johan De Meersman wrote: Having this line commented, we have to rely on logrotate.conf to have something similar defined and we see an error when using mysql-rotate Then something else is wrong. Does your MySQL daemon happen to run as a user who can normally not create

logrotate script doesn't create a new log file

2012-02-22 Thread Honza Horak
Hi all, I'm thinking of logrotate script, that is shipped in mysql tar ball (e.g. mysql-5.5.20/support-files/mysql-log-rotate.sh). There is a commented line # create 600 mysql mysql, that should originally ensure logrotate utility creates a new log file after rotating. Is there any

Re: logrotate script doesn't create a new log file

2012-02-22 Thread Johan De Meersman
- Original Message - From: Honza Horak hho...@redhat.com particular reason why the line is not used by default? Can't be bothered to go look at the script, but it should be doing a flush logs somewhere. The line is commented by default because MySQL will recreate it's logfiles

How to split a mysqldump file of multiple databases to singlefile databases... SOLVED with script

2012-02-20 Thread Andrés Tello
Today I needed to split a mysqldump -A into it several databases. I didn't have access to the original source, so I only had the texr file to work. It was a webhosting server dump, so there was a LOT of databases... I split the file with this little script I made: file=myqdl dump file nextTable

Re: Script for cleaning data on a regular basis

2012-01-27 Thread Johan De Meersman
- Original Message - From: Halász Sándor h...@tbbs.net Therefore, it well may be easier to do it all in PHP, since therewith I agree with the assessment, but I take issue with this whole do it in PHP/Python/language-of-the-month. Why would I want to install PHP, Python or whatever on

Re: Script for cleaning data on a regular basis

2012-01-27 Thread Karen Abgarian
The original problem is traditionally resolved by partitioning the tables by historical range and creating a database job/event to drop older partitions and add the new ones. Depending on the environment, some might prefer shell scripts to do essentially the same. On Jan 27, 2012, at 3:08

Re: Script for cleaning data on a regular basis

2012-01-27 Thread walter harms
which became more than 2 years old , so i need a script for this (shell, php etc) . Can you please help me for this script ? and also which mysql command must be used drop, trunk? You can, if you are careful, write an SQL procedure for dropping the appropriate tables. Since MySQL has

Re: Script for cleaning data on a regular basis

2012-01-26 Thread Hal�sz S�ndor
a script for this (shell, php etc) . Can you please help me for this script ? and also which mysql command must be used drop, trunk? You can, if you are careful, write an SQL procedure for dropping the appropriate tables. Since MySQL has no table variables, if you do this you will need PREPARE

Script need for dropping databases

2011-11-18 Thread a bv
to make this job auto, i need a linux/mysql script which will run on cron etc . Can you please help me for a correct script ? (i cant say im a database guy :-) Regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Script need for dropping databases

2011-11-18 Thread Mohan L
the table which became the data container of 2 years previous data. So to make this job auto, i need a linux/mysql script which will run on cron etc . Can you please help me for a correct script ? (i cant say im a database guy :-) It may help : http://www.cyberciti.biz/faq/how-do-i-empty-mysql

Re: Script need for dropping databases

2011-11-18 Thread Nuno Tavares
Hi unknown, Have a look at database information_schema.TABLES: SELECT * FROM information_schema.TABLES WHERE TABLE_SCHEMA='database'; As long as your MySQL version is = 5.1, you don't need a cron script, you can use the MySQL scheduler, create a stored procedure that will run each month. You'll

Re: Why the same command have different results when it is in a bash script and when it is not?

2011-10-11 Thread Johan De Meersman
tcp/ip instead, use -h 127.0.0.1 It's possible that the execution environment of a script is subtly different and causes the client to interpret it the other way, but I've no idea what the exact difference would be. - Original Message - From: Peng Yu pengyu...@gmail.com To: mysql

Re: Why the same command have different results when it is in a bash script and when it is not?

2011-10-10 Thread Rik Wasmus
It is seems strange to me why the same command mysql -hlocalhost -uxxx when it is run from the command line, it will show an error. When it is run in a bash script, it runs fine. I guess this might be described somewhere, but I'm yet to find the answer. Does anybody know why this happens

Why the same command have different results when it is in a bash script and when it is not?

2011-10-09 Thread Peng Yu
Hi, It is seems strange to me why the same command mysql -hlocalhost -uxxx when it is run from the command line, it will show an error. When it is run in a bash script, it runs fine. I guess this might be described somewhere, but I'm yet to find the answer. Does anybody know why this happens

Script to mail output of select query

2011-03-15 Thread Adarsh Sharma
Dear all, I have prepared a simple script that shows the database, tables size in the Database server as :- Please check the attachment for the script output. Now I just want to mail the output of my script to some persons e-mail-ID Also, I want to do some calculations and provide

Re: Script to mail output of select query

2011-03-15 Thread Johan De Meersman
- Original Message - From: Adarsh Sharma adarsh.sha...@orkash.com Please check the attachment for the script output. Thanks for your password :-) Now I just want to mail the output of my script to some persons e-mail-ID Assuming you run this from crontab, just set MAILTO=per

Re:Incremental Backup Script

2010-10-13 Thread kranthi
Hi Please be send sample incremental backup script (bash Shell script Easy to understand) Thanks Regards, Kranthikiran

Re: Incremental Backup Script

2010-10-13 Thread Shawn Green (MySQL)
On 10/13/2010 9:18 AM, kranthi wrote: Hi Please be send sample incremental backup script (bash Shell script Easy to understand) Thanks Regards, Kranthikiran I think you missed the points of the previous replies. MySQL does not do incremental backups the the same way

Re: Sequence of Execution in Non-Transactional Script

2010-08-30 Thread Paul DuBois
On Aug 30, 2010, at 12:09 PM, real...@areality.co.uk wrote: Hello, I'm working on a very simple stock tracking system on unix with MySQL 5 and PHP. Working under the assumption that all my updates would be executed sequentially in the order they appear in the PHP script I perform

input from script

2010-08-14 Thread xPol
Hi, i am very new to databases. I would like to know if new entries can be added to my database from the character terminal. Hints for achieving such result by a shell script welcome. thank you ---Pol -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: input from script

2010-08-14 Thread Buford Tannen
xPol wrote: Hi, i am very new to databases. I would like to know if new entries can be added to my database from the character terminal. Hints for achieving such result by a shell script welcome. http://www.catb.org/~esr/faqs/smart-questions.html -- MySQL General Mailing List For list

Re: script of mysql

2010-08-02 Thread PRATIKSHA JAISWAL
Hi Travis, Thanks a lot for your help, Can i have a same scrip for windows OS. On Sat, Jul 31, 2010 at 3:29 AM, Travis Ard travis_...@hotmail.com wrote: Something like this mysql-summary script might be useful: http://code.google.com/p/aspersa/wiki/mysql_summary -Travis

RE: script of mysql

2010-08-02 Thread Travis Ard
Sorry, I am not aware of a windows-specific version.  You might check with the script author, or you may be able to get this to work on windows by installing cygwin and using a bash shell. -Travis Date: Mon, 2 Aug 2010 12:20:57 +0100 Subject: Re

script of mysql

2010-07-30 Thread PRATIKSHA JAISWAL
Hi List, Can somebody please help me if they have a script using which we can get an idea for installed mysql server, backup, created databases, indexes, tables, engines, replication etc... I will appreciate your help in advance Thanks Pratiksha

Re: script of mysql

2010-07-30 Thread walter harms
PRATIKSHA JAISWAL schrieb: Hi List, Can somebody please help me if they have a script using which we can get an idea for installed mysql server, backup, created databases, indexes, tables, engines, replication etc... I will appreciate your help in advance You can find tons

RE: script of mysql

2010-07-30 Thread Travis Ard
Something like this mysql-summary script might be useful: http://code.google.com/p/aspersa/wiki/mysql_summary -Travis Date: Fri, 30 Jul 2010 12:19:07 +0100 Subject: script of mysql From: pratikshadjayswa...@gmail.com To: mysql@lists.mysql.com Hi

Running a MySQL script in phpMyAcmin

2010-02-14 Thread John
I am trying to help a friend with her website, which is on Yahoo. I went into her phpMyAdmin, and got the message: Your PHP MySQL library version 3.23.49 differs from your MySQL server version 4.1.14. This may cause unpredictable behavior. Another message told me to run the script

login problem from django script, using python2.5/MySQLdb/connections.py

2009-12-09 Thread John Griessen
If I can login from a shell, what could stop a script from login? I'm following a newbie tutorial for django, a web content mgt. system. The following user and password are good if I use them fromthe same shell the script launches from. Here's the error message from a django script using

Re: login problem from django script, using python2.5/MySQLdb/connections.py

2009-12-09 Thread John Griessen
John Griessen wrote: If I can login from a shell, what could stop a script from login? privileges were stopping it and at first, maybe a mistake in GRANT setup of a new user. Nevermind JG -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

RE: login problem from django script, using python2.5/MySQLdb/connections.py

2009-12-09 Thread Gavin Towey
Access Denied means you're using an incorrect username and password combination. Test your credentials using the mysql cli. You can log in as root to mysql to make changes as necessary, or supply the correct user/pass from your script. Regards, Gavin Towey -Original Message- From

Re: How to Backup the Database using Script

2009-10-29 Thread Scott Haneda
and password that has read access to all databases. You only need read access, no more, no less. I then set the permissions on this script itself to read/write/execute for root only. There is a small window in which the data is being dumped in which the permissions of the dump files are a little

How to Backup the Database using Script

2009-10-28 Thread Ganeswar Mishra
Hi Everyone, I am trying to backup a database regularly, without using Administrator tool in mysql, Can anyone help to write a scipt regarding backup database. -Thanks in Advance Ganeswar

A mytop automation shell script (someone may find useful)

2009-03-31 Thread Daevid Vincent
http://www.daevid.com/content/examples/snippets.php scroll down to Automatic Monitoring of remote servers You'll need Gnome, ssh keys (for remote execution), .mytop file, wmctrl and xtrlock.

Re: generic remote command/script for monitoring MySQL instance health

2009-03-11 Thread Thomas Spahni
On Mon, 9 Mar 2009, Sven wrote: Hi folks I am searching for a generic command to monitor that MySQL instance is up and running. I don't have any know-how about the schema of the DB. kind regards Sven Aluoor Hi What about 'mysqladmin ping' ? Regards, Thomas Spahni -- MySQL General Mailing

Re: generic remote command/script for monitoring MySQL instance health

2009-03-11 Thread Sven
On 3/11/09, Thomas Spahni t...@lawbiz.ch wrote: I am searching for a generic command to monitor that MySQL instance is up and running. I don't have any know-how about the schema of the DB. What about 'mysqladmin ping' ? Hi Thomas thank you. That was the command I searched. kind regards

generic remote command/script for monitoring MySQL instance health

2009-03-09 Thread Sven
Hi folks I am searching for a generic command to monitor that MySQL instance is up and running. I don't have any know-how about the schema of the DB. kind regards Sven Aluoor -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: generic remote command/script for monitoring MySQL instance health

2009-03-09 Thread walter harms
you may like to try mytop or watch -n10 mysql -BNA databasename -e show full processlist add user,host,databasename as needed Sven schrieb: Hi folks I am searching for a generic command to monitor that MySQL instance is up and running. I don't have any know-how about the schema of the DB.

Re: Re: Re: MySQL 5.1.31 PostInstall Script Error

2009-02-10 Thread bunti
installation script is the first package-related program. From what I see here you are using a Solaris 8 on Sparc 64bit Cpu, is it right? Claudio bunti wrote: Hi I am doing investigation to determine whether we can use MySQL in our project. But I got error message when I try

Re: Re: Re: MySQL 5.1.31 PostInstall Script Error

2009-02-10 Thread Claudio Nanni
procedure of the solaris package manager the post installation script is the first package-related program. From what I see here you are using a Solaris 8 on Sparc 64bit Cpu, is it right? Claudio bunti wrote: Hi I am doing investigation to determine whether we

Re: Re: MySQL 5.1.31 PostInstall Script Error

2009-02-09 Thread bunti
information about your platform. My impression is that you are using the wrong binaries, probably after the common copy procedure of the solaris package manager the post installation script is the first package-related program. From what I see here you are using a Solaris 8 on Sparc 64bit Cpu

MySQL 5.1.31 PostInstall Script Error

2009-02-09 Thread bunti
information about your platform. My impression is that you are using the wrong binaries, probably after the common copy procedure of the solaris package manager the post installation script is the first package-related program. From what I see here you are using a Solaris 8 on Sparc 64bit Cpu

Re: Re: MySQL 5.1.31 PostInstall Script Error

2009-02-09 Thread Claudio Nanni
about your platform. My impression is that you are using the wrong binaries, probably after the common copy procedure of the solaris package manager the post installation script is the first package-related program. From what I see here you are using a Solaris 8 on Sparc 64bit Cpu

MySQL 5.1.31 PostInstall Script Error

2009-02-06 Thread bunti
in postinstall scripts but still got installation successful message. Server : Solaris 5.8 MySql : 5.1.31 Package used : mysql-5.1.31-solaris8-sparc-64bit.pkg.gz ## Executing postinstall script. /opt/mysql/mysql/bin/my_print_defaults: syntax error at line 1: `^?ELF^B^B^A^B+^A^A^AZ\200@' unexpected /opt

Re: MySQL 5.1.31 PostInstall Script Error

2009-02-06 Thread Claudio Nanni
Hi, I just try to guess because you don't post much information about your platform. My impression is that you are using the wrong binaries, probably after the common copy procedure of the solaris package manager the post installation script is the first package-related program. From what I see

script to cycle through servers to retrieve 'mysql' schema/data

2009-01-23 Thread Daevid Vincent
Here's a little script for the google cache and email archive engines to store in case anyone ever needs this. We have several servers (dev/test/prod) and replication setup too. Sometimes we need to restore one server from another, however we have different mysql user accounts setup on each

Problem with mysql_secure_installation script in mysql-5.0.67

2009-01-07 Thread sjh
script in mysql-5.0.67 Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-5.0.67 (Source distribution) Server: ./mysqladmin Ver 8.41 Distrib 5.0.67, for pc-solaris2.10 on i386 Copyright (C) 2000-2006 MySQL AB This software comes

Re: Inno Setup script for MySQL and MySQL ODBC?

2008-12-27 Thread Yves Goergen
On 20.12.2008 00:51 CE(S)T, Steve Holmes wrote: 2008/12/19 Menachem Bazian gro...@bcconsultingservices.com Does anyone have an inno setup script so I can automatically install MySQL with an application? http://lists.mysql.com/mysql?unsub=sholme...@gmail.com I don't know about anyone else

Inno Setup script for MySQL and MySQL ODBC?

2008-12-19 Thread Menachem Bazian
Does anyone have an inno setup script so I can automatically install MySQL with an application? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Inno Setup script for MySQL and MySQL ODBC?

2008-12-19 Thread Steve Holmes
2008/12/19 Menachem Bazian gro...@bcconsultingservices.com Does anyone have an inno setup script so I can automatically install MySQL with an application? http://lists.mysql.com/mysql?unsub=sholme...@gmail.com I don't know about anyone else, but I don't know what you mean by inno setup

Inno Setup Script?

2008-12-13 Thread Menachem Bazian
Does anyone have an inno setup script to install MySQL and MySQL ODBC using Inno Setup? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

mysql script

2008-03-24 Thread Kaushal Shriyan
Hi I have created a script http://pastebin.com/m2c9cc100. is this syntactically correct, just want to make sure before running it Thanks and Regards Kaushal

script command timeout

2008-01-15 Thread Éric Fournier/CSPQ
Hi everyone , I'm using a script file to do the reset master command every saturday to clean up the log files. My script is called by a bigger script that stop mysql , take server backup , then start mysql. Just after the start command is issued the reset master

MySQL to blame? (was Re: Command-line PHP script, MySQL CPU usage goes sky-high, stays there--why?)

2007-12-20 Thread M5
restart the script. So I stop the [seemingly offending] script and wait for CPU load to return to normal. It doesn't. MySQL remains at 80-90%. Even with all the other processes turned off that call MySQL and Web Server off, MySQL remains at 80-90%. Yet SHOW PROCESSES lists no processes, just

Command-line PHP script, MySQL CPU usage goes sky-high, stays there--why?

2007-12-10 Thread René Fournier
Hello, I have a command-line PHP script--called Listener--that is designed to run indefinitely with a predictable CPU usage and memory footprint. In a nutshell, it's a multi-client socket server that waits for incoming connections, processes incoming data, stores results in a MySQL

Re: Can't fetch result twice in a PHP script

2007-09-16 Thread Néstor
mysql_num_rows() http://www.php.net/manual/en/ref.mysql.php :-) On 9/15/07, Chris W [EMAIL PROTECTED] wrote: Mahmoud Badreddine wrote: it is more of a PHP question , I admit. I tried mysql_fetch_array, mysql_data_seek, mysql_result . Same result. And I am sure there's more than zero rows

Can't fetch result twice in a PHP script

2007-09-15 Thread Mahmoud Badreddine
I am using mysql 4.1.11 and PHP 5 In one of my php scripts I make 2 successive calls of mysql_fetch_row using the same Mysql Result. In the first call the desired result is achieved, but in the second one it isn't. I have something like while($someArr=mysql_fetch_row($result)) { ...some code. }

Re: Can't fetch result twice in a PHP script

2007-09-15 Thread Chris Sansom
At 16:35 -0500 15/9/07, Mahmoud Badreddine wrote: In one of my php scripts I make 2 successive calls of mysql_fetch_row using the same Mysql Result. In the first call the desired result is achieved, but in the second one it isn't. I have something like while($someArr=mysql_fetch_row($result)) {

Re: Can't fetch result twice in a PHP script

2007-09-15 Thread Mahmoud Badreddine
it is more of a PHP question , I admit. I tried mysql_fetch_array, mysql_data_seek, mysql_result . Same result. And I am sure there's more than zero rows to be fetched, because it works in the first call, but not the second. On 9/15/07, Chris Sansom [EMAIL PROTECTED] wrote: At 16:35 -0500

Re: Can't fetch result twice in a PHP script

2007-09-15 Thread Kevin Waterson
This one time, at band camp, Mahmoud Badreddine [EMAIL PROTECTED] wrote: I have something like while($someArr=mysql_fetch_row($result)) { ...some code. } The first time I call mysql_fetch_row , the code inside the while loop gets executed, but not the second time. What is the reason

Re: Can't fetch result twice in a PHP script

2007-09-15 Thread Chris W
Mahmoud Badreddine wrote: it is more of a PHP question , I admit. I tried mysql_fetch_array, mysql_data_seek, mysql_result . Same result. And I am sure there's more than zero rows to be fetched, because it works in the first call, but not the second. That just means there is one row in the

SCRIPT OR TOOL TO GIVE CHANGES IN DATABASES

2007-08-29 Thread Krishna Chandra Prajapati
Hi All, Is there is any script or tool that generate the report and send an email for changes done in the databases; There is any otherway (manual) So that i can look that what changes has been done in the database today. Regards, Krishna

Re: SCRIPT OR TOOL TO GIVE CHANGES IN DATABASES

2007-08-29 Thread Alex Arul Lurthu
of the performance implications. -- Alex http://alexlurthu.wordpress.com/ On 8/29/07, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: Hi All, Is there is any script or tool that generate the report and send an email for changes done in the databases; There is any otherway (manual) So

Re: SCRIPT OR TOOL TO GIVE CHANGES IN DATABASES

2007-08-29 Thread Edoardo Serra
Hi Krishna, you can use MySQL binlog to see queries that made changes to db data Hope it helps Regards Krishna Chandra Prajapati ha scritto: Hi All, Is there is any script or tool that generate the report and send an email for changes done in the databases; There is any otherway

Re: SCRIPT OR TOOL TO GIVE CHANGES IN DATABASES

2007-08-29 Thread Ananda Kumar
Prajapati ha scritto: Hi All, Is there is any script or tool that generate the report and send an email for changes done in the databases; There is any otherway (manual) So that i can look that what changes has been done in the database today. Regards, Krishna -- MySQL

Release of Installation/Management script for MySQL Cluster (NDB)

2007-08-03 Thread Jim Dowling
Hi all, I'm releasing an installation script for installing/managing a MySQL Cluster (NDB). http://forge.mysql.com/projects/view.php?id=228 or http://www.jimdowling.info/ndbinstaller-trac/ The script enables a quick install of cluster (you should be able to install and start a localhost

Need script to populate data.

2007-05-25 Thread SRM SRM
)NO (null) (null) (null) title_clean varchar(100)NO (null) (null) (null) description textYES (null) (null) description_clean textYES (null) (null) options int(10) unsignedNO (null) 0 (null) I need a script that will insert

Need script to populate data.

2007-05-25 Thread SRM SRM
)NO (null) (null) (null) title_clean varchar(100)NO (null) (null) (null) description textYES (null) (null) description_clean textYES (null) (null) options int(10) unsignedNO (null) 0 (null) I need a script that will insert

Re: Need script to populate data.

2007-05-25 Thread Ryan Stille
) description_clean text YES (null) (null) options int(10) unsigned NO (null) 0 (null) I need a script that will insert, say 1, records into this table. Note, I dont really care about the content of the data (ie, the title could be TITLE1, TITLE2, TITLE3...TITLE1, whatever). Im just

Re: Need script to populate data.

2007-05-25 Thread SRM SRM
Ryan, Thanks for your help. I'm not able to ssh into this box - how can I run this script, basically all I have to work with is MySQL Query Broswer. TIA From: Ryan Stille [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: Re: Need script to populate data. Date: Fri, 25 May 2007 13:19

Re: Need script to populate data.

2007-05-25 Thread Dan Nelson
In the last episode (May 25), SRM SRM said: Thanks for your help. I'm not able to ssh into this box - how can I run this script, basically all I have to work with is MySQL Query Broswer. You can generate data by using a stroed procedure, too. I prefer this method because it doesn't

Bash script array from MySQL query - HELP Please!!!

2007-05-22 Thread Ben Benson
I'm having problems getting a monitoring script to run. I've put the troublesome bit in a separate script just to test, and it goes like this: declare -a HNdeclares the array HN HN=(`echo SELECT url FROM hosts | mysql --user=netmon --password=n3tm0n --skip-column-names

Re: Bash script array from MySQL query - HELP Please!!!

2007-05-22 Thread BJ Swope
I would look at the 15th URL to see if there are specials in there that are breaking the hash somehow. On 5/22/07, Ben Benson [EMAIL PROTECTED] wrote: I'm having problems getting a monitoring script to run. I've put the troublesome bit in a separate script just to test, and it goes like

Re: dbnightly maintenance backup script

2007-05-16 Thread Ofer Inbar
) = localtime(time); $year+=1900; $mon++; I forgot to increment month in the code that names the full dump file, so it got named with 0-based month numbers (that is, 200704 for May). It's fixed. If you got the script, get it from there or add the increment. -- Cos -- MySQL General Mailing List

dbnightly maintenance backup script

2007-05-10 Thread Ofer Inbar
I wrote a perl script to handle all of our regular mysql maintenance tasks, which I thought might be useful to others. It's meant for an enviroment with binary logging turned on, but is fairly flexible. Although if you're backing up multiple databases you'll have to modify it a bit, since in our

RE: dbnightly maintenance backup script

2007-05-10 Thread Daevid Vincent
- From: Ofer Inbar [mailto:[EMAIL PROTECTED] Sent: Thursday, May 10, 2007 12:24 PM To: mysql@lists.mysql.com Subject: dbnightly maintenance backup script I wrote a perl script to handle all of our regular mysql maintenance tasks, which I thought might be useful to others. It's meant

help on loading the world.sql(script and data) onto world database

2007-05-09 Thread kebede teferi
hi, it's my first time trying my hand in inputting data in batches to mysql database and it drives me crazy, please help. *I've created the WORLD database. *I've downloaded WORLD.SQL and unzipped the file. *When I open it in notepad I see the instructions to create the three tables and

Re: help on loading the world.sql(script and data) onto world database

2007-05-09 Thread Juan Eduardo Moreno
Kebede, Send some example of WORLD contains. Regards Juan On 5/9/07, kebede teferi [EMAIL PROTECTED] wrote: hi, it's my first time trying my hand in inputting data in batches to mysql database and it drives me crazy, please help. *I've created the WORLD database. *I've downloaded

Re: problem with initdb script in lxr installation - newbie needs help

2007-05-08 Thread Shahbaz Khan
version is 5.0.22. The script requires 4.x. If Fedora core 6 allows without dependency issues I have no problem with 4.x. Anyways I think it would be better if the script can be corrected because it will be useful for the majority newbies like me. On 5/7/07, Michael Dykman [EMAIL PROTECTED] wrote

Re: problem with initdb script in lxr installation - newbie needs help

2007-05-08 Thread Mogens Melander
that corresponds to your MySQL server version for the right syntax to use near 'release char(255) bunary not null, primary key (fileid,relea' at line 3 MySQL server version is 5.0.22. The script requires 4.x. If Fedora core 6 allows without dependency issues I have no problem with 4.x. Anyways I think

problem with initdb script in lxr installation - newbie needs help

2007-05-07 Thread Shahbaz Khan
This portion of the script gives error. reate table lxr_releases (fileid int not null references lxr_files, release char(255) binary not null, primary key (fileid,release) The script is present as attachment if needed. I suspect this script is for mysql

a script to archive binary logs

2007-05-02 Thread Ofer Inbar
the destination, you can't easily use rsync to make the backups, since it won't correctly identify which files need to be copied or deleted. So I wrote this script, which syncs one directory to another, gzip'ing the resulting files - but only files whose name matches a regex you set

error with the script mysql_install_db

2007-04-28 Thread Thibaud Hulin
Hello, I'm trying to install mysql 4.1 After the installation, I launch the script for the post-installation, in scripts/mysql_install_db I get this error : Could not find help file 'fill_help_tables.sql' in ./support-files or inside .. When I try to go on phpmyadmin, it doesn't work

Re: Trying to open a big sql script

2007-04-20 Thread Joerg Bruehe
Hi! Duncan Hill wrote: On Thursday 19 April 2007 15:53:54 molemenacer wrote: I am trying to change all the names of the database from mthosp to another name, is this possible? Assuming you mean tables, not database (as mysqldump doesn't store the database name in the dump file [or at least

Re: Trying to open a big sql script

2007-04-20 Thread Gerald L. Clark
Joerg Bruehe wrote: Hi! Duncan Hill wrote: On Thursday 19 April 2007 15:53:54 molemenacer wrote: I am trying to change all the names of the database from mthosp to another name, is this possible? Assuming you mean tables, not database (as mysqldump doesn't store the database name in

Trying to open a big sql script

2007-04-19 Thread molemenacer
Hi all, I have backed up a database using mysqldump and have a .sql script that is over 2GB in size. I am trying to open this file to view it and make some changes. I have not been able to find a program that can open this file. Does anyone have any suggestions as to a program that can do

Re: Trying to open a big sql script

2007-04-19 Thread Duncan Hill
On Thursday 19 April 2007 11:43:34 molemenacer wrote: Hi all, I have backed up a database using mysqldump and have a .sql script that is over 2GB in size. I am trying to open this file to view it and make some changes. I have not been able to find a program that can open this file. Does

Re: Trying to open a big sql script

2007-04-19 Thread Dan Buettner
PROTECTED] wrote: Hi all, I have backed up a database using mysqldump and have a .sql script that is over 2GB in size. I am trying to open this file to view it and make some changes. I have not been able to find a program that can open this file. Does anyone have any suggestions as to a program

Re: Trying to open a big sql script

2007-04-19 Thread Mogens Melander
On Thu, April 19, 2007 12:48, Duncan Hill wrote: On Thursday 19 April 2007 11:43:34 molemenacer wrote: Hi all, I have backed up a database using mysqldump and have a .sql script that is over 2GB in size. I am trying to open this file to view it and make some changes. I have not been

Re: Trying to open a big sql script

2007-04-19 Thread Michael Dykman
It might be a little late for this advice but mysqldump has some useful options for this kind of thing. When I use it to create full snapshots, I use a script which generates a separate schema file per table/view and keep the data in one or more per table for data. naming conventions keep keep

Re: Trying to open a big sql script

2007-04-19 Thread molemenacer
. Edit the smaller files, then use shell command to cat them all back into one bigger file. HTH, Dan On 4/19/07, molemenacer [EMAIL PROTECTED] wrote: Hi all, I have backed up a database using mysqldump and have a .sql script that is over 2GB in size. I am trying to open this file

Re: Trying to open a big sql script

2007-04-19 Thread Duncan Hill
On Thursday 19 April 2007 15:53:54 molemenacer wrote: I am trying to change all the names of the database from mthosp to another name, is this possible? Assuming you mean tables, not database (as mysqldump doesn't store the database name in the dump file [or at least never has for me]): sed

Re: Trying to open a big sql script

2007-04-19 Thread Mogens Melander
. HTH, Dan On 4/19/07, molemenacer [EMAIL PROTECTED] wrote: Hi all, I have backed up a database using mysqldump and have a .sql script that is over 2GB in size. I am trying to open this file to view it and make some changes. I have not been able to find a program that can open

RE: Trying to open a big sql script

2007-04-19 Thread Andreas Iwanowski
Subject: Trying to open a big sql script Hi all, I have backed up a database using mysqldump and have a .sql script that is over 2GB in size. I am trying to open this file to view it and make some changes. I have not been able to find a program that can open this file. Does anyone have any

a Linux -csh script to refresh test with production

2007-03-27 Thread Brown, Charles
Hello all. Does anyone out there (in mysql world) have a Linux -csh script to refresh test with production data. My developers would like their test database to be refreshed nightly with production data. The production and test mysql servers do not run in the same box. They run on different

Re: a Linux -csh script to refresh test with production

2007-03-27 Thread Rolando Edwards
] To: mysql@lists.mysql.com Sent: Tuesday, March 27, 2007 3:17:46 PM (GMT-0500) Auto-Detected Subject: a Linux -csh script to refresh test with production Hello all. Does anyone out there (in mysql world) have a Linux -csh script to refresh test with production data. My developers would like

RE: a Linux -csh script to refresh test with production

2007-03-27 Thread Bessares, Bob
this helps bb -Original Message- From: Brown, Charles [mailto:[EMAIL PROTECTED] Sent: Tue 3/27/2007 12:17 PM To: mysql@lists.mysql.com Subject: a Linux -csh script to refresh test with production Hello all. Does anyone out there (in mysql world) have a Linux -csh script to refresh test

  1   2   3   4   5   6   >