Running MySQL Using A Dos Batch File
I am used to use MySQL on Unix, now I have to do some development for MySQL running on Windows machine. The following script works well in Unix but I am unable to run it on Windows. "MY_FLAG" is the one which is causing issue. Due to certain restriction in my framework, I can use the normal batch by supplying the .sql file while opening the mysql connection ( infact i need to run multiple source files) Code:
View Complete Forum Thread with Replies
Related Forum Messages:
Running Mysql Commands In A Batch File
I am trying to automate a mysql command to upload data everymorning on a windows server. I have created a .bat file and entered the commands to login to mysql but when it gets to the mysql prompt it fails to complete the rest of the commands. cd c: cdmysqlin mysql TRUNCATE TABLE blah LOAD DATA INFILE 'blah.txt' INTO blah QUIT exit Is this possible?
View Replies !
Running A Sql Batch Script From The Linux Command
s this possible? I want to write a command script which i want to put into a cron job which will download a db backup from cpanel. then i want to unzip it, and run the sql file, so keeping the database on the mirror machine up to date. So what i have is: #get the database wget -v --http-user user --http-pass pass https://www.site.com/path/to/cpanel/backup #move to backups folder date=`date -I` mv -fv ./mysqldump.gz /home/user/dbbackup/$date.gz now what i also want to do is: mysql -uuser -ppassword u database set foreign_key_checks = 0; . mysqldumpfile.sql set foreign_key_checks =1; exit is it possible to do that last bit from the command-line? as far as i know, a shell script can't run commands to mysql?
View Replies !
Verifying Connection To MySQL Database In A Batch File
I have a Windows batch file that I'm using to call another batch file that connects to my MySQL database. The password is obtained from the user via a prompt and passed into the 2nd batch file where the connection to the database is made. I'm having a hard time figuring out how to verify that the user entered the correct password. How would I go about testing the connection in the 1st batch file before calling the 2nd batch file?
View Replies !
Batch File
I am new to running batch files. Is there a way to loop through a results set in a batch file? I want to be able to create tables using table names that are stored in a table. I had hoped that I could query the table to retrieve all tablenames, then loop through this result set, creating a table with each tablename returned. (Table definitions will be the same for all tables created. Only the tablenames are different.)
View Replies !
Running Mysql Code Within A Php File?
I have been given a some mysql code that I have to run within a website - I am familiar with mysql in terms of insert info and querying a database but I at a loss as to how to make this work. the mysql code works in mysqladmin, but how do I call it into my php code? BTW the mysql code creates a new record in the database ....... Also, I need to tweak the code so it runs in a loop for different variables - in php I would run a FOREACH query, how do I do it in mysql?
View Replies !
Create And Run Batch File
I am using CentoS. I have mysql installed. I want to run around 60 queries. Whats the best way to do it ? If batch file then how to create batch file and how to run it in mysql environment ?
View Replies !
Cant Execute Batch File
Hi new to this but pulled out nearly all my hair with this. I got the test database open and I want to automate creating the menagerie table ( as in the tutorial ) so I download the textfile save it to c:/ and execute the command source c:/cr_pets_tbl.txt all I get is unable to open file error 22. I have tried creating my own text file ( windows, notepad ) just containing the following use test; create table pets(name varchar(10),species varchar(8),born date); simple as that then type in the consoe source c:/pets.txt; unable to open file error 22 or sometimes error 2 tried enclosing filename in " and ' tried source= filename tried . instead of source but nothing works. using manual insert command or load data local infile works but not this, HELP. Malcolm K.
View Replies !
Using Batch-/cmd-file For Dumping Data
i want to build in data in my database that are written in single table dumps like [tablename].sql. Each time it is nececery to use several files. And it is also nececary to do this using the command line because of the files are bigger than 1,5 gb But i didnt find a way to transfere the needed commands into the mysql command line.
View Replies !
How To Execute A Batch Sql File Under Windows?
I have installed MySQL 5 in c:Program FilesMysql. I have a sql file named "books.sql" which is put in the subfolder in,it contains many statements that like "INSERT ... value ...". my question is how to execute it? I try it, but failed. One more question is how can I return from "->" to "sql>" promopt?
View Replies !
Mysqlimport :: Run A Batch File To Import From CSV
I want to be able to run a batch file that imports a csv file to a mysql table. This seems like a perfect job for mysqlimport, but I have some questions first. Here is what a typical line looks like: 00002,7/6/2005,7:37:15 AM,me@me.com,55337 My first issue is the date and time. I want these to be converted to mysql date and time format. Is there a way to do this directly with a mysql command? Second issue is that I want to run mysqlimport on a machine that doesn't have mysql. It will connect to a machine that does. It seems that mysqlimport only comes if you install mysql, which I don't want to do on the client machine. Third issue is that actual command. I want to be able to pipe out the output to a file. So overall the command would be import this csv file to this table, converting dates and times, and output the result to a text file.
View Replies !
Running Existing .sql File In Mysql Command Prompt?
I've seen "examples" of this in my book on MySQL, but it just shows the file on the prompt. It says that I can run an existing sql file - for creating a table - right from the prompt. However, it doesn't really explain how to do this in detail. I've tried : -h host - u user -D database -p < myfile.sql but it gives an error. How do I point it to the right file on my system?
View Replies !
Mysqld-nt Crashes When Executing Batch File In 5.03 Beta
I'm quite new to mysql but I had installed the 5.0.1 and 5.0.0a alpha under windows XP, and designed a little database for managing cards. To make some backup of this database I dumped it in a batch file. This file was working perfectly with mysql 5.0.1 and 5.0.0a. When I try and execute my batch file, having previously created the database concerned, it crashes the mysqld-nt. On top of that the first table created in the database is listed but when a DROP DATABASE is issued it says that this table does not exist and then the command fails. The database uses UTF8 and SET FOREIGN_KEY_CHECKS=0; is set in the begining of the file. So I have two questions : 1- Can I force the database to be dropped or is it definitely corrupted? 2- Any clue on why the batch file crashes the server? (I'd be glad to send it is is a mere 250 ko when zipped)
View Replies !
Running An Existing SQL File
I hope this question is not too 'newbie' to answer.. I'm reading a book (PHP and MySQL web development by Luke Welling and Laura Thomson), and am getting an error on an example script. I'm trying to create tables using an existing SQL file through MySQL. According to the book, it should be done like this: > mysql -h hostname -u username -D database -p < file.sql (I've changed the hostname, username, etc.) However, I get the same error over and over again: ERROR 1064 (42000): ... at line 1. The book didn't even mention where to put the file, I've tried all sorts of things, but can't get it to work..
View Replies !
Running Script File
I want to write mysql code like create table ... and insert into ... in text file and run the codes in mysql. I have installed mysql in my machine windows xp. and the help says the mysql> source (filename) will work to run the code file. but it does no work. says could not open the file. I am not sure where should i put my code file and the extension of the file required.
View Replies !
Running Sql File From Shell Script
When i run the command "mysql -h host - u user - p password -D database <file.sql" (the file.sql contains an Update Scrpit) from command prompt /usr/test> mysql -h host - u user - p password -D database <file.sql i am able to run the file and i am getting expected results. When i copy the same string in a shell script (suppose in update.sh) and try running it from the command prompt /usr/test> . update.sh i get an error as "No file or directory found" i tried giving in the full path of file.sql and tried running hte shell script but it gave me the same results "No file or directory found".
View Replies !
Mysql Batch Question
I'm writing this here because it's related to mysql. I'm using Mysql with PHP and because Mysql 4 doesn't support stored procedures, I would like to run several scripts from one database connection. In running a multi-line sql.txt file externally I can do this by delimiting the statements with a semi-colon so I tried to do the same: $strsql = ""; $strsql = "delete from tbl1 where tbl1ID = '1';"; $strsql = $strsql . "delete from tbl1 where tbl1ID = '2';"; $strsql = $strsql . "delete from tbl1 where tbl1ID = '3';"; $result = @mysql_query($strsql, $db); I'm not getting an error; the sql scripts simply won't run.
View Replies !
Batch Mode Feedback Of "mysql" Command Line Tool
while writing a bash shell script to backup some databases and I am having slight problems with the mysql command line tool's feedback. Here goes command line: #!/usr/bin/env bash mysql -ubackup -e "UPDATE `mydb`.`sysvar` SET `val`='backup' WHERE `var`='updateState' AND `val`='0';" The backspaces are nescessary for the shell, otherwise it'd interpret whatever is inclosed in --> ` <--- as command. The problem is, I need to know wether a line has changed or not. The command always returns 0 (that is a success in Unix/Linux) if it was successfully executed, no matter wether or not a line had been changed, and produces no output at all. Could anyone tell me how I get that info?
View Replies !
Running MySQL
I have installed mysql-3.23.54-win and it all seems to have gone OK .... now i want to run it and setup a database. I dont have an icon on the desktop and there is nothing in Start - Programs ..... start it from DOS prompt via C:> C:mysqlinmysql.exe and i get error 2003 cant connect to MySQL server on localhost <10061>
View Replies !
Running MySQL 5.0
I've just downloaded and installed 5.0 on my Pc/ win 98se. When I run the program MySQL Command Line Client, it appears to run for a second then disappears. I see the program flash open for a second and then it is gone.Complete newb needs some help.
View Replies !
MySQL 4.1 Running
I've been running mysql 4.1 for sometime and using phpMyAdmin (v2.6.2) to administer the databases. Using php scripts I can also update/insert etc the databases (maintained on my laptop Mac OS X Tiger). Suddenly, I can't get phpMyAdmin to load in the browser. I've also tried other MySQL GUI tools like CocoaMySQL and Navicat....they won't run either. I downloaded and installed phpMyAdmin 2.6.3-pl1 as well but no improvement. Why would mysql run but the admin apps not work?
View Replies !
Running MySQL From A CD-ROM?
I have used PHP and MySQL for a few years now. Just today I can across an application that had a MySQL database running locally off a CD ROM. I did not know this was posible. When the application runs it starts up the MySQL database without the user even knowing they are running it. It is pretty amazing. So I want to do the same thing. Is there any documentation on how to run MySQL locally. I would like to know how to build the database and create tables under these curcumstances.
View Replies !
Could Not Get MySQL Running
I went to MS-DOS to start the MySQL application by typing mysqld into the bin directory of where I installed MySQL but once I did typed the command and pressed enter this is all I got : A moment passed before I am shown the path of bin with no indication of MySQL server started. And also I have installed this as a window service.
View Replies !
Help Please Running Mysql On Os X
I am very new to mysql. I am using the sitepoint book 'Build your own Database Driven Website using PHP and MYSQL. I have installed mysql mysql-5.0.41-osx10.3-powerpc. Under preferences/mysql it indicates that the mysql server is running. When I try to access mysql through the terminal window I get a message - command not found. Or no permissions. I can go to the bin directory and list the contents - they seem to be there. I can't get past page 21/22 Post-installation setup tasks. I am also new to using the terminal window. I suspect I have missed something really basic - any suggestions on how I can get up and running would be much appreciated!
View Replies !
Running MySQL In RAMDisk
Have a very large database and due to performance requirements it seems that running MySQL in RAMDisk might be a good solution. Access to the database is through PHP.
View Replies !
Running MySQL Win32
I'm an absolute beginner and would really like to read something in the manual to solve this problem, but the manual just take care of Unix and Linux users. Because we develop on NT we wanted to install MySQL with Apache and PHP3 on a NT workstation for faster testing beside our Linux station. But I have problem to start the program (mysql.exe). It just gives back an error: Error 2003: can't connect to MySQL server on localhost 10061 Network is running, I can ping localhost. I don't know what to do to get it running.
View Replies !
Running Backup For Mysql
Can anyone suggest a reliable and inexpensive backup service for mysql? I have about 50 tables, of which I've been doing database backups daily on the server, then downloading the backup every couple days or so. The backup files are starting to get relatively large, and I'd like to find a service to backup to off site.
View Replies !
Running Mysql From Shell
I need to run this sort of querys from shell: delete from 3dinformatica where preco = " " ; CREATE TABLE tudotest AS SELECT DISTINCT * FROM 3dinformatica; DELETE FROM 3dinformatica; INSERT INTO 3dinformatica (cr_datetime,produto,vendedor,preco,link) SELECT DISTINCT cr_datetime,produto,vendedor,preco,link FROM tudotest; DROP TABLE tudotest; i wanted to put the mysql cmd in a file like mysql.sh and run it from crontab. i have about 100 querys like that i need to run at the same time.
View Replies !
MySQL Config Not Running
i'm trying to set up MySQL with IIS 7.0 on Windows Vista Home Premium. After you install MySQL, there's a check box to launch the config app. if i leave it checked, the app does not load. if i try to run the app by double-clicking its icon it gives me an error saying, "The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log for more detail." I cannot find the application event log, though.
View Replies !
MySQL Running Very Slow
I have the following INSERT SQL, which runs very slow (For 2 full days it had not done anything) on a 2 processor Compaq machine running Suse Linux. Code:
View Replies !
Running Mysql On Old Computers
I´m running mysql on a Pentium 166 Mhz with 16 Mb of RAM. Pretty old, right? I want to know if there is a way to improve performance. I don´t know, something about reducing the number of queries that it will respond or cutting out some features.
View Replies !
Slow Running MySQL?
I'm hoping someone may have an idea what could be causing the slow loading pages of my web-site. I'm not positive, but I'm relatively sure that it's related to a problem with MySQL database. I purchased a program called Sam3 for broadcasting our radio signal over the internet. The software requires the use of MySql in order to set up web pages for our web site. The problem is, that while everything works GREAT (requests can be made from the site, songs can be searched, the history of what we've played shows up) the pages load PAINFULLY slow. Other users of this software have had no such problems so I'm at a loss. I know from testing that the PHP script for the web pages is fine, I have plenty of bandwith both upload and download available on my DSL line, and while the computer running MySQL is behind a router I have tried plugging the DSL line DIRECTLY into the host computer and it makes no difference. For all appearances it seems the problem is that it takes MySQL forever to gather and provide the information needed for these pages. Does anyone have any idea what I should be looking at to solve this problem? I do not know the MySQL program at all, so I get somewhat lost when people start throwing out technical terms, but this has been really frustrating because no one else seems to have the problem and everyone so far has just told me to check the things I've already checked.
View Replies !
On What Port Is MySQL Running?
I'm running MySQL on my Mac, and I'm trying to figure out on what port MySQL is running. What can I type into Unix terminal to figure this out? Or can I find out some other way?
View Replies !
How To Use A Copy Of A MYSQL 4.1 Database In MYSQL 5 Running On Ubuntu Linux
We had a "permanent world" game server running on an older PC, under Ubuntu 5.10, using a MYSQL 4.1 database to store persistent data for the players, then the hard disk quit. We did back up our data on a regular basis, but didn't use MYSQL to do the backups, we simply copied the MYSQL/data/ folder to disk. So now we have a new hard disk, with Ubuntu 7.10 and MYSQL 5 installed. We have everything working, in that we have created the appropriate database and, using a simple test module of our game which will create some of the tables if they don't exist in the database, we can store and retrieve data from the database tables. The problem we have is how in the world do we get the data from the backup copy of the MYSQL 4.1 created database into the new MYSQL 5 database correctly? With 4.1 we could copy the contents of the database folder right into the database folder in the /var/lib/MYSQL/ folder, but this procedure didn't work with MYSQL 5. The files seemed to copy, as in the copy operation gave no errors, but we get an error that says the database is unavailable and to make sure the MYSQL server is running - it is, so we're stumped, and our game server is offline.
View Replies !
Error Running MySQL Administrator On RH8
I have downloaded the latest version of mysql administrator 1.0.18. I followed the installation instructions, but when i am unable to run the program. I get an error saying: ./mysql-administrator-bin: relocation error: ./mysql-administrator-bin: undefined symbol: gdk_display_get_type Do you have any clue about what is happening?
View Replies !
How To Verify If MySQL Is Running On My Windows XP?
I uninstalled that and reinstalled that. Then it doesn't work anymore... I check the process of the "Windows Task Manager", but I couldn't find the fimilar mysql-nt.exe... Do you have any idea how should I fix this problem? Should I reinstall the whole XP system?
View Replies !
MySQL Administrator GUI Running Slowly... WHY?
We have created an instance or schema that contains over 14000 tables. It is a lot of tables. When we attempt to browse the tables in the GUI it literally takes 5 minutes or more for it to come back. Granted when using the Microsoft SQL Server Management Studio it is slow but doesn't take that long. After about a minute or so it gives the list and is kind of slow to scroll. Can this be fixed by optimizing the database? Is this just too many tables for mySQL to handle?
View Replies !
Detecting If MySQL Server Is Running
I write an application which saves/loads data to/from database. I created a table and I'm reading an informations from it. The problem is when server is stopped and my application tries to connect to database it terminates. I think it shouldn't happen. I want my application not to terminate while it can't to connect but give me some kind of error and continue its run. How can I do that? And at the end I would like to say that I'm writing my program in c++ using .net. My piece of code: ....
View Replies !
MySQL Running In Linux With Apache2
I have Fedora Linux running on my box. I have installed Apache2, PHP, MySQL. I used YUM to install everything. yum install httpd yum install php yum install mysql-server mysql yum instal php-mysql What I want to know is that how can I start playing around with all this cool programs. I want to learn as much about all these awesome programs. I would like to install some kind of control center for MySQL. I heard MyPHPadmin is good. But how do I install it? Can I do it through yum? Where can I find a good newbie guide? thanks in advance :-) Fedora Project Information is Power! I am doing this for the love of MySQL.
View Replies !
MySQL + SQL Server 2000 Both Running On XP Pro?
I've had mysql on my machine plenty of times with no trouble currently i have SQL Server 2000 Trial running but never both at once. Unfortunately i have to have them both on at the moment. So before i install and mess everything up, Does anyone here have this setup? I basically want to get php/mySQL/MSSQL running with IIS
View Replies !
|
TRACKER
