How to know Data Size through Scripts

Dear all, I am research on several commands through which I can monitor the size of specific data of tables in different . I want to write a script that fetches the data of different database tables & databases too daily and write it into a file . Is there is any way or commands to achieve

Automate Scripts to make for managing Large Database Servers.

Dear all, I am working on some common tasks that need to be performed on regular intervals in a large Database Servers. I find below lists of tasks that need to be performed and Please tell me if i missed some. 1. Tacking Daily, Weekly Backups. 2. Finding Space Occupied and Remaining in Data

Re: embedded client test scripts

Hi Alex, all! Alex Katebi wrote: > Any information on how to run the test scripts for the embedded client. Call the test script, "mysql-test-run.pl", and pass it the option --embedded-server It does not support replication or cluster, so you should add --skip-rpl --sk

embedded client test scripts

Any information on how to run the test scripts for the embedded client. Thanks, -Alex

Re: Some way/tool to do this with database scripts backups

DEN OUWELAND', ciudad='OTHER CITY' WHERE idCliente='000273999' UPDATE cliente SET razonCliente='I HAVE A NEW NAME', ciudad='AREQUIPA' WHERE idCliente='00454507' . maybe i would need create a C.sql in this way UPDATE cliente SET ciudad=&#

RE: Some way/tool to do this with database scripts backups

ed > warranties or liabilities. To the extent you are relying on this > information, you are doing so at your own risk. If you are not the > intended recipient, please notify the sender immediately by replying to > this message and destroy all copies of this message and any attac

RE: Some way/tool to do this with database scripts backups

Hi, > if i have for example > a simple table call person > > with 'id' and 'name' how columns > > i can do a backup and get some file (A.sql) > with all the inserts statements > > here, all fine > > but > how i can do this? Have a look at the 'mysqldump' command line utility. It goes somethin

Some way/tool to do this with database scripts backups

w B.sql, with update statements its possible do this? even worst, if a have a table with 20 columns i need the way to generate the same B.sql but with my desired columns to update thanks in advanced -- View this message in context: http://www.nabble.com/Some-way-tool-to-do-this-with-data

mysqlmanager startup scripts for Debian

Where possible I use distro builds of applications (let them worry about security updates and testing, means I don't need build tools on a production server), but all the distros I've checked use their own startup scripts which do not allow me to use mysqlmanager (or even mysqld_mul

Fwd: loading scripts to mysql

hi, Tanks for your help, finally i found the "source" command. It work like this: mysql> source /Lhome/geruppa/mhc/Pack_Ref_web/prova.sql 2007/11/9, Michael Gargiullo < [EMAIL PROTECTED]>: > > On Fri, 2007-11-09 at 13:22 +0100, Pau Marc Munoz Torres wrote: > > > Hi everybody > > > > I'm writi

Re: loading scripts to mysql

On Fri, 2007-11-09 at 13:22 +0100, Pau Marc Munoz Torres wrote: > Hi everybody > > I'm writing a function script in a flat file using vim, now i would like > load it into my sql, there is some command to do it similar to "load data > into" to fill tables? > > thanks > Sure, >From command lin

Re: loading scripts to mysql

You have basic instruction SELECT (for selection) and INSERT (for write in table) What case : . Take data in one table and transfer it in other table ( select / insert ) . Take data in a file and insert it in a table ( tools of conversion) 2007/11/9, Pau Marc Munoz Torres <[EMAIL PROTECTED]>: > >

loading scripts to mysql

Hi everybody I'm writing a function script in a flat file using vim, now i would like load it into my sql, there is some command to do it similar to "load data into" to fill tables? thanks -- Pau Marc Muñoz Torres Laboratori de Biologia Computacional Institut de Biotecnologia i Biomedicina

Re: Recommended backup scripts for mysql databases

ps on two locations to be even safer. In my setup I now have 3 my.sh scripts executed at the same time through a cronjob. Could it be problematic to do this at the same time or does it not matter? The databases aren't large. Cheers, Andreas

Re: Recommended backup scripts for mysql databases

Good morning Andreas - The --opt flag implies --extended-insert, in addition to some other options, to generate an optimized (fast) dump file. See man mysqldump. You don't need both but having both shouldn't hurt. To restore, pipe your dump file back into the mysql client, a la mysql -u user -

Re: Recommended backup scripts for mysql databases

I finally got the script working. Seems to run smooth on my FreeBSD 4.11system: MYSQLDUMP="`which mysqldump 2>/dev/null`" || MYSQLDUMP="/usr/local/bin/mysqldump" MYSQLDUMP_ARGS="--opt --extended-insert -h localhost -umyuser -pmypassword mydb" ARCHDIR=/backup/mysql NAME=db_dump # Remove archives

Re: Recommended backup scripts for mysql databases

Those warnings always give me pause, too - but I used mysqlhotcopy in production for about 5 years at my previous place of employment. Probably like the warnings about threading in perl 5.8 - been using threads in production for nearly 2 years without a problem. Only 2 problems with mysqlhotcopy

RE: Recommended backup scripts for mysql databases

nded? Tim > -Original Message- > From: Dan Buettner [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 29, 2006 6:01 PM > To: Tim Lucia > Cc: mysql@lists.mysql.com > Subject: Re: Recommended backup scripts for mysql databases > > That's a good thought, Tim - file grep

Re: Recommended backup scripts for mysql databases

; wrote: > -Original Message- > From: Dan Buettner [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 29, 2006 9:26 AM > To: Tim Lucia > Cc: mysql@lists.mysql.com > Subject: Re: Recommended backup scripts for mysql databases > > Hi Tim - those are all important conside

RE: Recommended backup scripts for mysql databases

> -Original Message- > From: Dan Buettner [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 29, 2006 9:26 AM > To: Tim Lucia > Cc: mysql@lists.mysql.com > Subject: Re: Recommended backup scripts for mysql databases > > Hi Tim - those are all important consideratio

Re: Recommended backup scripts for mysql databases

On 6/29/06, Tim Lucia <[EMAIL PROTECTED]> wrote: I am in the process of designing the backup procedures for a soon-to-be production DB. I have gone back and forth on mysqldump and mysqlhotcopy. As I see it (for MyISAM tables), the hot copy backs up faster, restores faster, but does not allow for

Re: Recommended backup scripts for mysql databases

Looks like your full command would end up being: mysqldump /usr/local/bin/mysql --opt -uroot -pmypassword db which makes little sense. (You don't need that ${MYSQL} in there). Instead, maybe what you want is to use an environment variable for mysqldump, a la MYSQLDUMP="`which mysqldump 2>/dev/nu

Re: Recommended backup scripts for mysql databases

Thanks for the examples. I haven't been able to get them to work yet. Here's what I tried: MYSQL="`which mysql 2>/dev/null`" || MYSQL="/usr/local/bin/mysql" MYSQL_ARGS="--opt -uroot -pmypassword db" ARCHDIR=/backup/mysql NAME=db_dump # Remove archives older than 64 days find ${ARCHDIR} -type f

Re: Recommended backup scripts for mysql databases

Widerøe Andersen > Cc: mysql@lists.mysql.com > Subject: Re: Recommended backup scripts for mysql databases > > Andreas, if you are only using MyISAM tables, the included mysqlhotcopy > script may work for you. We used it at my previous employer with good > results. We would run it t

Re: Recommended backup scripts for mysql databases

Tim Lucia wrote: I am in the process of designing the backup procedures for a soon-to-be production DB. I have gone back and forth on mysqldump and mysqlhotcopy. As I see it (for MyISAM tables), the hot copy backs up faster, restores faster, but does not allow for selective restores ("Hello, Sup

RE: Recommended backup scripts for mysql databases

lists.mysql.com > Subject: Re: Recommended backup scripts for mysql databases > > Andreas, if you are only using MyISAM tables, the included mysqlhotcopy > script may work for you. We used it at my previous employer with good > results. We would run it to create a snapshot of our da

Re: Recommended backup scripts for mysql databases

Andreas, if you are only using MyISAM tables, the included mysqlhotcopy script may work for you. We used it at my previous employer with good results. We would run it to create a snapshot of our data files every day, then run a network backup utility that backed up the snapshot (but did not a

Re: Recommended backup scripts for mysql databases

On Tue, Jun 27, 2006 at 08:19:41AM -0300, Daniel da Veiga wrote: > On 6/27/06, Andreas Widerøe Andersen <[EMAIL PROTECTED]> wrote: > >Hi, > >I have a few FreeBSD servers running various web/database things and I'm > >looking for a good a reliable backup script that I can run through a > >cronjob. I

Re: Recommended backup scripts for mysql databases

On 6/27/06, Andreas Widerøe Andersen <[EMAIL PROTECTED]> wrote: Hi, I have a few FreeBSD servers running various web/database things and I'm looking for a good a reliable backup script that I can run through a cronjob. I'm currently running the latest version of mysql323, but will upgrade to vers

Recommended backup scripts for mysql databases

Hi, I have a few FreeBSD servers running various web/database things and I'm looking for a good a reliable backup script that I can run through a cronjob. I'm currently running the latest version of mysql323, but will upgrade to version 4.1 soon aswell as upgrade most of the servers to the latest

BBEdit tip (was: Differences between MySQL 4 and 5 for scripts)

At 23:00 +0100 14/6/06, Graham Reeds wrote: 1) You may have a bogus hidden character in your SQL file. If you look at it with a text editor (BBEdit, TextWrangler, etc), with the "show invivisbles" feature on, do you see unusual stuff? Sounds strange but I've seen stranger. Took a brief look

Re: Differences between MySQL 4 and 5 for scripts

d at all. You should be fine with: DROP TABLE IF EXISTS Blog; or DROP TABLE IF EXISTS `Blog`; > >2) You could work around this problem a different way ... > > - create a 5.0 database yourself using the standard supplied scripts, > >perhaps on your own workstation >

Re: Differences between MySQL 4 and 5 for scripts

er. Took a brief look over it but didn't see anything that I thought looked untoward. Nor did side by side comparison show up anything. 2) You could work around this problem a different way ... - create a 5.0 database yourself using the standard supplied scripts, perhaps on your own work

Re: Differences between MySQL 4 and 5 for scripts

So I decided to see what I can do to make the database creation scripts MySQL4 compliant. The CHARSET was the easy one - just change it to CHARACTER SET but the next one was more tricky: The problem I am having is that version 4 fails giving a syntax error for the single quotation marks. It appear

Re: Differences between MySQL 4 and 5 for scripts

but I've seen stranger. 2) You could work around this problem a different way ... - create a 5.0 database yourself using the standard supplied scripts, perhaps on your own workstation - dump your new database structure using mysqldump with the flag --compatible=mysql40 which should cr

Differences between MySQL 4 and 5 for scripts

I can do to make the database creation scripts MySQL4 compliant. The CHARSET was the easy one - just change it to CHARACTER SET but the next one was more tricky: The problem I am having is that version 4 fails giving a syntax error for the single quotation marks. It appears the script (whic

Error while runnign ./scripts/mysql_install_db --user=mysql

SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `<' and `>'). SEND-PR: From: root To: mysql@lists.mysql.com Subject: [Error while runnign ./scripts/mysql_install_db --user

Re: Nested scripts in MySQL?

As it turns out, it is entirely possible to nest scripts to multiple levels. For instance I now have: Create_And_Load_Tables.sql --- \. Create_Tables.sql \. Load_Tables.sql --- Create_Tables.sql

Re: Nested scripts in MySQL?

: Monday, January 16, 2006 10:29 AM Subject: RE: Nested scripts in MySQL? -Original Message- From: Rhino [mailto:[EMAIL PROTECTED] Sent: Monday, January 16, 2006 09:10 To: mysql Subject: Nested scripts in MySQL? Is it possible to run nested scripts in MySQL? I tried this with succe

RE: Nested scripts in MySQL?

> -Original Message- > From: Rhino [mailto:[EMAIL PROTECTED] > Sent: Monday, January 16, 2006 09:10 > To: mysql > Subject: Nested scripts in MySQL? > > Is it possible to run nested scripts in MySQL? > I tried this with success. Create a file that

Nested scripts in MySQL?

Is it possible to run nested scripts in MySQL? If I want to run a script called TestA1.sql where TestA1.sql contains: select * from Sample.emp; all I need to do is go to the MySQL command prompt and enter: \. TestA1.sql That's a single, un-nested script and it works fine. Now, supp

RE: backup scripts

716-878-3895 Cell: 716-432-4978 [EMAIL PROTECTED] Tom Crimmins <[EMAIL PROTECTED]> 03/03/2005 03:06 PM To [EMAIL PROTECTED] cc mysql@lists.mysql.com Subject RE: backup scripts Kelly, You can find out what user mysqld is running as with the following: #ps axu | grep mysqld

RE: backup scripts

ollowed the directions from: >> http://dev.mysql.com/doc/mysql/en/backup.html >> >> I also attempted to follow these directions, to no avail: >> -- >> mysqlhotcopy, etc is great - but using it (and most other myql >> automation scr

RE: backup scripts

he directions from: > http://dev.mysql.com/doc/mysql/en/backup.html > > I also attempted to follow these directions, to no avail: > ------ > mysqlhotcopy, etc is great - but using it (and most other myql > automation scripts) requires placing a user/

backup scripts

ns from: http://dev.mysql.com/doc/mysql/en/backup.html I also attempted to follow these directions, to no avail: -- mysqlhotcopy, etc is great - but using it (and most other myql automation scripts) requires placing a user/password on the command line for all/some to

Re: ANNOUNCE: SHSQL - SQL for LINUX/UNIX Shell scripts

Wow - cool idea - nice job. Looking forward to playing with it. David. Eddy Macnaghten wrote: Hi all I have just released a utility (under the GPL) that enables SQL to be incorporated into UNIX/LINUX shell scripts (easier than using psql or similar with better integration). For more information

ANNOUNCE: SHSQL - SQL for LINUX/UNIX Shell scripts

Hi all I have just released a utility (under the GPL) that enables SQL to be incorporated into UNIX/LINUX shell scripts (easier than using psql or similar with better integration). For more information see http://www.edlsystems.com/shsql To download ftp://ftp.edlsystems.com/shsql (needless to

Sample MySQL 5 scripts wanted

Hi all, I'm going to test some stuff with scripts that include Stored Procedures/Functions and a lot more. Could someone provide me with some huge scripts that include tables, indices, FKs and some Stored Prcedures or Functions? If so, please do so - much appreciated. With regards, Ma

Re: 1 database; 2 scripts; different results

Michael Stassen wrote: Amer Neely wrote: Both scripts, which reside in the same directory on the server, are run through the web browser. And they do access the same database, and the same tables. So, same web server, same mysql server, same connection settings. Good. Does phpmyadmin connect

Re: 1 database; 2 scripts; different results

Michael Stassen wrote: Amer Neely wrote: Both scripts, which reside in the same directory on the server, are run through the web browser. And they do access the same database, and the same tables. So, same web server, same mysql server, same connection settings. Good. Does phpmyadmin connect

Re: 1 database; 2 scripts; different results

Amer Neely wrote: Both scripts, which reside in the same directory on the server, are run through the web browser. And they do access the same database, and the same tables. So, same web server, same mysql server, same connection settings. Good. Does phpmyadmin connect to mysql as the same user

Re: 1 database; 2 scripts; different results

Michael Stassen wrote: Amer Neely wrote: OK, obviously a bit more background seems to be in order. My site is hosted but I am not the administrator. I have 2 perl scripts, behaving as already described. I also have phpMyAdmin access to my databases. I don't have command line access t

Re: 1 database; 2 scripts; different results

Amer Neely wrote: I'm pretty sure it's not. With a properly functioning mysql server, you need neither FLUSH TABLES nor the RELOAD privilege to delete a row from a table. See the manual for a description of FLUSH TABLES . I did and imagine my sur

Re: 1 database; 2 scripts; different results

Amer Neely wrote: OK, obviously a bit more background seems to be in order. My site is hosted but I am not the administrator. I have 2 perl scripts, behaving as already described. I also have phpMyAdmin access to my databases. I don't have command line access to the server. Well, that'

Re: 1 database; 2 scripts; different results

shows 103. The record does show up in the 'public' script, so it's not just a mis-count. How is this possible? Is there a step I'm missing because I'm using 2 different scripts to access the same tables? That doesn't make sense. Can someone shed some light on what

Re: 1 database; 2 scripts; different results

shows 103. The record does show up in the 'public' script, so it's not just a mis-count. How is this possible? Is there a step I'm missing because I'm using 2 different scripts to access the same tables? That doesn't make sense. Can someone shed some light on what

Re: 1 database; 2 scripts; different results

show up in the 'public' script, so it's not just a mis-count. How is this possible? Is there a step I'm missing because I'm using 2 different scripts to access the same tables? That doesn't make sense. Can someone shed some light on what might be happening here?

Re: 1 database; 2 scripts; different results

'public' script, so it's not just a mis-count. How is this possible? Is there a step I'm missing because I'm using 2 different scripts to access the same tables? That doesn't make sense. Can someone shed some light on what might be happening here? Web caching? Flushi

Re: 1 database; 2 scripts; different results

other script. The admin script shows 102 records and the other shows 103. The record does show up in the 'public' script, so it's not just a mis-count. How is this possible? Is there a step I'm missing because I'm using 2 different scripts to access the same tables? Tha

Re: 1 database; 2 scripts; different results

script, so it's not just a mis-count. How is this possible? Is there a step I'm missing because I'm using 2 different scripts to access the same tables? That doesn't make sense. Can someone shed some light on what might be happening here? Web caching? Flushing tables after y

Re: 1 database; 2 scripts; different results

script, so it's not just a mis-count. How is this possible? Is there a step I'm missing because I'm using 2 different scripts to access the same tables? That doesn't make sense. Can someone shed some light on what might be happening here? Web caching? Flushing tables after y

Re: 1 database; 2 scripts; different results

so it's > not just a mis-count. How is this possible? Is there a step I'm missing > because I'm using 2 different scripts to access the same tables? That > doesn't make sense. Can someone shed some light on what might be happening > here? Web caching? Flu

1 database; 2 scripts; different results

I have one database that is currently being accessed by 2 scripts which query the database. One is for me to administer the db contents. The other is for public display, and so has the final buttons disabled for 'Delete', 'Add', 'Modify', 'Dump', and &#x

RE: Scripts - ERROR

Have you tried running this from the mysql monitor? -Original Message- From: Andre MATOS To: Victor Pendleton Cc: '[EMAIL PROTECTED] ' Sent: 7/8/04 5:33 PM Subject: RE: Scripts - ERROR Hi, I tried but didn't work. He

RE: Scripts - ERROR

ndre MATOS > To: [EMAIL PROTECTED] > Sent: 7/8/04 12:20 PM > Subject: Scripts > > Hi List, > > Let's suppose that I have a script to create one database (tables, > indexes, etc). > > How can I call another script from this script? For example: > > DR

RE: Scripts

not sure if it's what you're looking for... but you can always do mysql>"system -uuser1 -ppassword mailto:[EMAIL PROTECTED] Sent: Thursday, July 08, 2004 10:21 AM To: [EMAIL PROTECTED] Subject: Scripts Hi List, Let's suppose that I have a script to create one databas

RE: Scripts

Have you tried writing the script using the source command? drop database; create database; source populate_db; -Original Message- From: Andre MATOS To: [EMAIL PROTECTED] Sent: 7/8/04 12:20 PM Subject: Scripts Hi List, Let's suppose that I have a script to create one dat

Scripts

Hi List, Let's suppose that I have a script to create one database (tables, indexes, etc). How can I call another script from this script? For example: DROP DATABASE test; CREATE DATABASE test; (here call another script) back to the previous script Thanks. Andre -- Andre Matos [EMAIL PR

Re: sql scripts

Dudley F. Cañas wrote: hi ppl, im a newbie to mysql but been using oracle for quite sometime now and i found that mysql is not bad at all :) i was just wondering if is there an equivalent scripting method of coding like plsql scripts in mysql... ? TIA Stored Proceedures are currently

sql scripts

hi ppl, im a newbie to mysql but been using oracle for quite sometime now and i found that mysql is not bad at all :) i was just wondering if is there an equivalent scripting method of coding like plsql scripts in mysql... ? TIA

SQL Scripts web site

Hello, This is an announcement to all MySQL developers. I have opened my web site www.SQL-Scripts.com up to MySQL . This means that you can now search for scripts for MySQl and other database system on this site. www.SQL-Scripts.Com is targeted at becoming the number on search engine for

Re: Span a database transaction across multiple CGI scripts

06:24 am, Sagara Wijetunga wrote: > Hi all > > Is it possible to span a database transaction across > multiple CGI scripts? That is, start transaction and > lock some records in one CGI script and update and > commit in another CGI script. > > Here is an example: I have a

Span a database transaction across multiple CGI scripts

Hi all Is it possible to span a database transaction across multiple CGI scripts? That is, start transaction and lock some records in one CGI script and update and commit in another CGI script. Here is an example: I have a accounts database. Only one user should edit a given account at any given

Re: My backup scripts and how reliable are they?

on 02/27/2004 09:53 AM, Adam Hardy at [EMAIL PROTECTED] wrote: > On 02/26/2004 09:02 AM Scott Haneda wrote: >> As per the reco of someone on this list, I created a bash script that runs >> once a day to do the following: >> >> # set path to final destination >> location="/Volumes/foo/sql_dumps/"

Re: My backup scripts and how reliable are they?

On 02/26/2004 09:02 AM Scott Haneda wrote: As per the reco of someone on this list, I created a bash script that runs once a day to do the following: # set path to final destination location="/Volumes/foo/sql_dumps/" # set db_list to the list of databases db_list=`echo "show databases" | /usr/local

My backup scripts and how reliable are they?

As per the reco of someone on this list, I created a bash script that runs once a day to do the following: # set path to final destination location="/Volumes/foo/sql_dumps/" # set db_list to the list of databases db_list=`echo "show databases" | /usr/local/mysql/bin/mysql -N -u -p` for d

My backup scripts and how reliable are they?

As per the reco of someone on this list, I created a bash script that runs once a day to do the following: # set path to final destination location="/Volumes/foo/sql_dumps/" # set db_list to the list of databases db_list=`echo "show databases" | /usr/local/mysql/bin/mysql -N -u -p` for d

Login scripts

Hey guys, Im trying to build a login system with Phpmyadmin and php, with dreamweaver. I use the coder view to code my pages. Would any of you guys be willing to help a rookie Out. Ive tried to read and follow tutorials but I have a hard time manipulating it towards my code and site! Anyone int

RE: FW: running sql-bench scripts redhat 8.0

Well looks like it has quite a few dependencies. I'll have to install these other dependencies -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 25, 2003 12:10 AM To: jason steig Subject: RE: FW: running sql-bench scripts redhat 8.0 >Thank

RE: FW: running sql-bench scripts redhat 8.0

Thank you much! -Original Message- From: Michael Weiner [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 11:18 PM Cc: [EMAIL PROTECTED] Subject: Re: FW: running sql-bench scripts redhat 8.0 looks like you'll need to install the perl-DBD-mysql rpm to satisfy the requir

Re: FW: running sql-bench scripts redhat 8.0

At 23:11 -0500 11/24/03, jason steig wrote: Hi all, I'am getting this error when I try to run any of the sql-bench tests. For instance, here is an attempt to run the test-connect script. This happens to me when I try any of the scripts. I attempted to change the location my perl install a

Re: FW: running sql-bench scripts redhat 8.0

ttempt to run the test-connect script. This > happens to me when I try any of the scripts. I attempted to change the > location my perl install at the beginning of the script(RH 8.0) can > anyone help me with this? Anyone else with Redhat run into this > problem? > > Thanks >

FW: running sql-bench scripts redhat 8.0

Hi all, I'am getting this error when I try to run any of the sql-bench tests. For instance, here is an attempt to run the test-connect script. This happens to me when I try any of the scripts. I attempted to change the location my perl install at the beginning of the script(RH 8.0) can a

Re: running sql-bench scripts redhat 8.0

At 9:13 -0500 11/23/03, Jason Steig wrote: I'am having trouble running all the scripts in sql-bench. It seems to be an issue with the location of my perl install. I tried to change the perl location at the start of the script to the location of my perl install /usr/bin but that didn'

running sql-bench scripts redhat 8.0

I'am having trouble running all the scripts in sql-bench. It seems to be an issue with the location of my perl install. I tried to change the perl location at the start of the script to the location of my perl install /usr/bin but that didn't fix the issue. has anyone else had

Showing multiple results in multiple pages, this scripts doesnt work!

Hi, im using this script to show the query results, basically it shows multiple results in multiple pages, when more than one result are found it shows the first one and on the bottom of the pages it shows the number of pages that remains, but fot some strange reason when you click on the first

RE: How to generate sql scripts in Mysql?

r snake If you want to get the interactive output format in batch mode, use mysql -t. To echo to the output the commands that are executed, use mysql -vvv. You can also use scripts in the mysql command-line prompt by using the source command: mysql> source filename; Andy > -Origin

How to generate sql scripts in Mysql?

Hi, Hope someone can guide me how to generate sql scripts in Mysql?Thanks. regards, florence Yahoo! Games - Who Wants to Be A Millionaire? Play now!

Re: Scripts with arguments

* Enrique Andreu > Hello, I think I have explained bad. I want to pass > the arguments to the sql script. > The argument is for the sql script. > > For example: > myscript.sql should be: > GRANT ALL PRIVILEGES ON *.* TO &1@'%' > where &1 would be parameter 1 > > I want to do something like that: >

RE: Scripts with arguments

Hello, I think I have explained bad. I want to pass the arguments to the sql script. The argument is for the sql script. For example: myscript.sql should be: GRANT ALL PRIVILEGES ON *.* TO &1@'%' where &1 would be parameter 1 I want to do something like that: dos>mysql mysql -u root -p < myscript

RE: Scripts with arguments

Enrique Andreu [mailto:[EMAIL PROTECTED] > Sent: Friday, August 29, 2003 12:36 PM > To: [EMAIL PROTECTED] > Subject: Scripts with arguments > > > Hello. > I have to do an script to create MySQL users, the name > of the new user have to be a parameter of the script. > I ha

Scripts with arguments

Hello. I have to do an script to create MySQL users, the name of the new user have to be a parameter of the script. I have no idea, someone can helps me. I'm an NT user. Thanks: Enrique Andreu ___ Yahoo! Messenger - Nueva versión GRATIS Super We

MySQL startup scripts

Hi, Would anyone explain me why the startup scripts check for command line arguments and the contents of /etc/my.cnf right after setting the env variables such as basedir, pid-file and so? if the MySQL code and scripts are expected to be on a specific hardcoded location (yeah, right we could

Re: Uploading scripts in MySQLGUI

ean X" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, 26 June, 2003 14:53 Subject: Uploading scripts in MySQLGUI Hi there, Is there a way to upload a saved script file into the GUI window to execute? On the GUI interface, there are SAVE, EXECUTE buttons. But I ca

Uploading scripts in MySQLGUI

Hi there, Is there a way to upload a saved script file into the GUI window to execute? On the GUI interface, there are SAVE, EXECUTE buttons. But I cannot find anything for uploading, even copying functions. Thanks for the help. Regards, Sean Tang

Re: Simple Question: MySQL and Shell Scripts

On 24-Jun-2003 Fred Whipple wrote: > Don't forget to use '-B' in order to make the output silent except for > the results: > and -N to suppress column names. > 2. you should stick your password (which shouldn't match > your UNIX password) in a textfile readable only by you so that

Re: Simple Question: MySQL and Shell Scripts

Joseph Bueno wrote: Zach wrote: I am writing a shell script using Born Shell. I am trying to get the result of a SQL statement into a variable. For example: /usr/bin/mysql -uroot -prootpass BOB << EOF SELECT * FROM Bobstable WHERE Name=1 EOF How do I get the result into a variable? But this is mor

Re: Simple Question: MySQL and Shell Scripts

On Mon, Jun 23, 2003 at 06:37:17PM -0500, Zach wrote: > > I am writing a shell script using Born Shell. I am trying to get the result of a SQL > statement into a variable. You mean Bourne shell. > For example: > > /usr/bin/mysql -uroot -prootpass BOB << EOF > SELECT * FROM Bobstable WHERE Name=1

Re: Simple Question: MySQL and Shell Scripts

Zach wrote: I am writing a shell script using Born Shell. I am trying to get the result of a SQL statement into a variable. For example: /usr/bin/mysql -uroot -prootpass BOB << EOF SELECT * FROM Bobstable WHERE Name=1 EOF How do I get the result into a variable? Thanks in advance! May be: myva

Simple Question: MySQL and Shell Scripts

I am writing a shell script using Born Shell. I am trying to get the result of a SQL statement into a variable. For example: /usr/bin/mysql -uroot -prootpass BOB << EOF SELECT * FROM Bobstable WHERE Name=1 EOF How do I get the result into a variable? Thanks in advance!

  1   2   3   >