MYSQL :: Switching To Shell Prompt

Switching Databases
I have a vbulletin forum right now and would like to switch to phpBB. But I cannot loose any members or posts. Someone told me I can switch the vbulletin database with the phpbb one, or import everything to phpbb from vbulletin(except the hacks/mods). Is this even possible? Is there a program for it?

Switching Domains
I switched domain names through my web host and I'd like to know if my My SQL tables/users, etc. can typically be found somewhere in/on my server?

Here's the server info (from netcraft if that help):

Linux Apache/1.3.33 Unix mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.3.11 FrontPage/5.0.2.2635 mod_ssl/2.8.22 OpenSSL/0.9.7a

Switching Characters
I've got a text string like a date eg 01-Jan-2001, is there a neat way
in an SQL statement to replace Jan with 01, Feb with 02 etc?

Quick Tip: Switching Field On/off
Ever wanted to change a database field (typically TINYINT(1)) from 1 to 0 or from 0 to 1 depending on the current value?

No need for two queries. I just thought of this 'clever' way to take care of it. Never saw that done this way before, and should have thought earlier about this.

UPDATE articles
SET published = ABS(published - 1)
WHERE id = x

Switching From Ms Access To MySql
1. Is Mysql secure than MsAccess (there are softwares avilable to
retrieve Ms Office Password)

2. Which 3rd Party tool Would You recommend for Administration,Query
creation.... Etc

3.Any tools for setup Mysql database to ship with ApplicationProgram
(Access need not be installed in a Windows machine)

4.Any known problems in a VB6/VB.Net - Mysql Combinations

Switching Indexing Types
I am still a novice when it comes to MySQL and I was wondering if switching
the indexing from INDEX to a FULLTEXT would have any dramatic
repercussions on current searches based on the the INDEX format?

I have 3 indexed fields: unit_id, customer_id, facility_id all in one
table called units. I would like to do text searches unit ids but
also account for user mistakes, like incomplete unit ids and return
all possible matches.
Doing some research on the MySQL site, they have lots of examples
based on FULLTEXT indexed fields.

Switching From Access To MySQL
On the "programming part" am i going to have to do my queries differently? Updates and all that differently? I recall people asking my database, then saying "I dont know how access does that" when having problem programming something... i have over 100 pages and 30 tables and don't really want to change but heard i should have done it about 100 pages and 30 tables ago :P So after I switch am i doing to have to change my code too?

Need Advice On Switching From Sql2000 & Access To Mysql
Im a coldfusion programmer, so it all started for me learning on access db's. Then sql 2000. Along the way, I started installing the cms systems and learning how mysql | phpmyadmin worked and really started to prefer this.

The .htaccess control is whats making my decision for me. I just cant control urls enough using IIS & coldfusion.

I have found a host that supports coldfusion running on the lamp platform.

To convert the sites, I figure 2 major tasks:
1. Converting the databases over to mysql
2. Making sure all my queries function properly.

I figure converting wont be too bad, but Im wondering how much structural differences exist between T-sql and the syntax mysql uses.

At most, my queries to convert are 3 tables using LEFT OUTER JOIN or INNER JOINS.

Any feedback on the process will be most appreciated
(I cant wait to get off IIS)

Switching Assigned Database For An Established Connection
I am implementing a connection pool using the C API. In my pool, The first time a connection is made, I call mysql_init(&myConn), and then use this myConn connection structure to call mysql_real_connect() with the appropriate user name, password, and a database name to connect to. Once the connection is established, it is used for the current database query and then put back into the pool.

My question is regarding using multiple databases with a single connection pool. If I pop an established connection off the pool and the database it is currently assigned to does not match the requested database of the new query, what do I do?

Do I close the existing connection and create another with the new database name? If so, wouldn't this defeat the purpose of having sustained connections?

What I first tried was to simply call mysql_real_connect() again with the new database name. This worked, but using MySQLAdministrator to look at the list of open connections/threads, I see the original connection was not closed, and I no longer have a handle to it, so it is lost.

Here is some pseudo code:

Log Into MySQL Via Shell?
i can't figure out how to log into mysql via the shell. I am using Microsoft Windows 2000 SP4, so I would guess that I have to use the CMD... but I can't figure it out. I have the 'root' user setup and a password set on it... and i know how to control my databases and create tables and modify them and everything in PHP... but i want to know how in the shell so I don't have to create a new php page and execute it every time.

Shell And Mysql
I am trying to run a mysql batch script through the shell. The one
problem though is that the error messages out of my script dont go to
the redirect i.e., if I run

mysql<test.sql>test.log

the error messages do no print into test.log, but to the command line.
I would like to capture the errors into this log file as well. Any
ideas?

Shell And Sql Dump
Does anyone know where I can find information on how to setup my shell in
unix/linux to allow me to restore a database from an sql dump...
I have a database on 83200.mysql.com (example) that I have a file mysql.sql
(also just an example).
The file was produced using an sqldump command from a web interface...
How can I configure a connection if I am not on 83200.mysql.com so that I
can import the data into a database with a name of database_wordpress

How Can I Open MySQL Shell
I want to see shell in following stage:

Code:

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.

Access Mysql Via Shell
I am trying to run queries against a mysql DB, for which I've been provided a uid & pwd, but for this I first have to login as:

CODEmysql -u xx -p
password: xxxx
use dbName;
query

Linux Korn Shell 93
I have several korn shell scripts I use with a MySQL database on the
same server (Solaris). I am moving to a Linux environment where the
MySQL database is on another server. I would like to convert the
database connection code to connect to the database on another Linux
server. I see alot of information on Perl DBI CLI and PHP DBI CLI but
cannot find any examples of Korn Shell connecting to a database on
another server.Is there a way to accomplish a network connection to a MySQL database
from Korn Shell?

Get Shell Throgh Mysql Db
i want to know if its pssosible to gets MS DOS access with MySQL Control Center or another remote control tool for mysql databank

Linux Shell Commands
in mysql database upon update on tables mysql should intimate to the OS process that a table got updated...
how can we make it?
is any ways to do that....
updation should trigger some C or C++ function?

Mysql Shell Startup Script
When starting up the mysql shell, is there a way that I can automatically run a startup-script ?
Specifically, I would like to issue a BEGIN WORK everytime I open up the shell. I tried man mysql, but didn't get any the wiser.

Send Request From Shell To Database
Is there a meaning to send data from the Unix's Shell to a mysql database?

Execute A Shell Command Inside SQL
I wonder if there is anyway you can run a shell command inside SQL.
for example "SELECT * FROM table;execute shell command"
I had googled around and didn't find anything.

Using Shell Script To Create Tables
I have several dozen tables to create and lots of them have a lot of fields. It is easy to create these tables using MyPHPAdmin or any other GUI tool but I want to make it even easier :|)

I wrote this script:
CODEmysql -u filepro -pfilePro -e "CREATE TABLE 'eglwms.jose2' (
'field_01' VARCHAR(10),
'field_02' DECIMAL(9,2) DEFAULT '0.00' NOT NULL,
'field_03' VARCHAR(10) NOT NULL,
'field_04' VARCHAR(10) NOT NULL,
'field_05' VARCHAR(10),
PRIMARY KEY ('field_03'),
INDEX ('field_04'),
UNIQUE (
'field_01'
),
) COMMENT = 'Ocean Export BL';"

Import Data From Shell Script
I've a comma separated file and would like to use "LOAD DATA LOCAL INFILE..." inside a shell script to import data into a table. Basically, I want the script to connect to database, complete import using "LOAD DATA..." and exit.

I understand, rows can be inserted one by one using database handles but I'd like this to be done using "LOAD DATA..." functionality.

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".

Sql Database From Linux Fedora's Shell
How may I restore *.sql databases from linux shell?

I've read the use of mysql command I don't have installed.
This is a remote server with preinstalled Apache-php-mysql.

Mysql User With Shell Access
Is there any reason the mysql user account in a linux system would need shell access and a password? I thought it was just there to be a very underprivileged user and run the mysqld daemon.

Create Database From Shell Command Line
From what I can see from the documentation, this does not appear to be an option.

Hope someone knows otherwise?

Cmd 'Prompt'
I've recently had to re-build my dev box and as part of the re-build I've re-installed v4.1 (for Windows). I'd previously had v4.1 BETA installed and in that I had a my.ini file setting that customized the cmd prompt to show the current database and user. The trouble is that in the production version of 4.1 the same ini file setting has no effect. I'm using an ini file setting of

[mysql]
prompt=u@h-d>

This definately worked for me in 4.1 BETA and it's what the MySQL documentation state is the way to do it. Once logged in I can manually make the setting by doing:

mysql> prompt u@h-d>

Executing Shell Command From Mysql Query Browser
This works fine when executing the shell command inside the MYSQL in command line

mysql> ! ls /home/www/htdocs/test
1000.xml class email test.xml test1.xml test2.xml

But when i execute the same with dynamic SQL and executed in TOAD for MYSQL, it throws error

SET @vSql:= '! ls /home/www/htdocs/test';
PREPARE vStmt FROM @vSql;
EXECUTE vStmt;

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '! ls /home/www/htdocs/middleware/test' at line 1

Can some one clarify me Whether is that possible to execute the Shell commands from the query browser or it can be only used in the command line?

How To Log Into The Mysql Through MS DOS Prompt
I had tried to login through the MS Dos Prompt mysql console

mysql -u root --password b
Enter password: *
ERROR 1049 (42000): Unknown database 'b'

The above is the output

What is the correct way to login.

USE Database Prompt
How do I know what database I am 'using' ?

I launch mysql from the command line. Type 'show databases', then pick a
database to use by typing 'use databasename'. I am now using that database
but have no visual cue.

How do I include the username, database name, etc in the 'mysql>' prompt?

Note, I can customize the command prompt on linux to include
user, host, directory, etc.. so I always know who I am and where I am.

USE Database Prompt
MySQL v 3.23.56 for pc-linux-gnu on i686

How do I know what database I am 'using' ?

I launch mysql from the command line. Type 'show databases', then pick a
database to use by typing 'use databasename'. I am now using that database
but have no visual cue.

How do I include the username, database name, etc in the 'mysql>' prompt?

Note, I can customize the command prompt on linux to include
user, host, directory, etc.. Code:

Cannot Log On Via Command Prompt.
Our entertainment division uses MySQL as the database of choice for their various websites. They are not command-line-type people (who would want to that? i mean I like command line OK, but I'm weird). Using their PHP Admin program, they administer the databases quite efficiently.

All of us can log on fine via the PHP interface. Additionally, I've installed the MySQL ODBC in a few places and it works fine. We all use the username root and password abc. No problems.

My problem is that I can't access the MySQL server via the command prompt.

I do this:
CODEc:mysqlinmysql -u root -p

Prompt Message
how to make alert message?
eg:
if (false) {
<- alert message ->
} else {
<- something ->
}
what coding to prompt alert message to user?

No Password Prompt
I'm trying to install mySQL on my WIN98 machine (I ran the setup.exe file), and am never prompted for a password when I run the configuration wizard. When I try to then run the command window, I'm asked for the password. Can I change some config file or ini file?
I'm selecting either Detailed or Standard Configuration, and don't ever get the prompt for password.
The checkbox for "Install as windows service" is disabled, so I can't check it.

Login Prompt
I have a script that uses MySQL and for some reason the first time it loads per session I get the prompt box to login to MySQL? It seems to be session based but is just weird

Prompt A User
Is there anyway in MySql to prompt a user to enter input and have it populate another table?

Login Prompt
I am having a hard time tracking to when it started. But basically in IE when I attempt to load a script for what it seems like the first time per session I get a login prompt open like what i see when I login in to MySQL, this script uses MySQL heavily.

Query Db From Remote Server Via Shell Script - Newbie, Be Gentle.
I'm looking to connect to a remote mySQL database from a UNIX server, but don't know how. I downloaded the 'connector' software from mysql.com, but the /bin directory is empty...

Am I missing something?

Command Prompt Shortcut
Each time I call up Command Prompt, I go through the long rigmarole till eventually I arrive at the MySql database. Is there a way to make shortcuts for Command Prompt so I could click on the shortcut and arrive straight at the database,

Online MySQL Prompt
My host provides me with its own MySQL prompt, called phpMyAdmin (in cPanel). It is quite hard to use, because it keeps on jumping to different pages after each prompt and incorrectly names my databases as "username_whateverINameIt". Is there any way to use a regular MySQL prompt (DOS style) as is directed from my book?

Paste Into Command Prompt
I've heard it said that you can copy and paste into mysql on Window's command prompt.

The normal way - Ctl-V - doesn't work for me. But once, when I had some documents resting on the keyboard, something actually did go from the Clipboard onto the command prompt screen.

Input Prompt Or Mysql
How do I prompt a user for input using mysql. I want the user to be able to input a a person's name which will then cause a query to run giving the required details. I was given this example to work from (from an oracle handbook) but it doesn't seem to work in mysql:-

select empno from emp where mgr = &Mgr_no;

Pre-empting The Password Prompt For Mysqldump
I would like to backup a mysql database automatically, say once a day. I understand that cron may be used to schedule such a task, but I first need to create a shell script which creates the database backup. (I am new to shell scripting, so please bare with me!) My first attempt was this:

#
# Creates a backup of the freelance database
#
mysqldump -h localhost -u root -p freelance > fldb_backup.sql;
When I run the script from the command line, I am prompted for my password. This would be no good if the script was scheduled, so I tried altering the command to this form:

mysqldump -h localhost -u root -p mypassword freelance > fldb_backup.sql;
When run, it still prompts for my password when. How can I get around this problem?

Call Sql Script From Unix Prompt
Is there a simple command I can use to call a sql script externally from Unix?

i.e.

I have a script with several sql statements within it. Kind of like a delta file which holds thousands of update. I don't want to do a full import because only 1 of the columns needs to be updated.

Accessing Mysql From Command Prompt
The path to my mysql installation is "C:Program Filesxamppmysqlin".

I want to run myisamchk - to do this I think I have to access it via the command prompt.

A stupid question - I kmow - but how do I get to the directory in a DOS window??

MySQL Command Line Prompt
In DOS mode, we can use for example dir/w-p to break the whole page to sub-page.
In MySQL prompt window, when I type "show variables", it blooms about 190 rows, but I can't scroll BACK to first 1-50 rows, by resizing the prompt windows it won't help.
So, I think is there any additional keys for pause the page like DOS mode?

Switching To Shell Prompt

how to switch to shell prompt from mysql prompt.