Hopeffully this will be the last question in this series. :)
I want to copy a database from my PC to my Apple laptop. I installed MySQL's
GUI Tools on both computers, created a file named Backup.mpb on my PC, then put
a copy of it on my Mac. Now I'm trying to figure out how to get Backup.mbp int
In the last episode (Oct 07), Cabbar Duzayak said:
> I am using mysql_pconnect from PHP to connect to our mysql server.
> However, whenever there is a temprorary surge in the number of users,
> i.e. concurrent users jump from 30 to 200 for like 5 minutes, Apache
> creates 200 processes and after th
David Blomstrom wrote:
OK, I'm halfway there. But I don't understand what you mean by "saved
settings." Is there some sort of default value I can try?
Also, if I can't recover my password, is there a file I can open and retrieve
it from?
I tried it with localhost, Port 3306, Username: root an
OK, I'm halfway there. But I don't understand what you mean by "saved
settings." Is there some sort of default value I can try?
Also, if I can't recover my password, is there a file I can open and retrieve
it from?
I tried it with localhost, Port 3306, Username: root and the password of one of
David Blomstrom wrote:
I just downloaded MySQL Administrator and am now trying to set it up. Can anyone tell me what "stored
connection" and "Server Host" mean? I'm using Apache on Windows XP, but I'm not sure what they
mean by Server Host. 3306 is listed under "Port" by default.
Also, what ar
I just downloaded MySQL Administrator and am now trying to set it up. Can
anyone tell me what "stored connection" and "Server Host" mean? I'm using
Apache on Windows XP, but I'm not sure what they mean by Server Host. 3306 is
listed under "Port" by default.
Also, what are the default username a
I am using mysql_pconnect from PHP to connect to our mysql server.
However, whenever there is a temprorary surge in the number of users,
i.e. concurrent users jump from 30 to 200 for like 5 minutes, Apache
creates 200 processes and after the surge is over, they die
gracefully, and # of processes g
Ah, that's better. I learned how to use Terminal just the other day. I'll check
out the other programs you recommended, too. Thanks.
- Original Message
From: Douglas Sims <[EMAIL PROTECTED]>
To: David Blomstrom <[EMAIL PROTECTED]>
Cc: mysql@lists.mysql.com
Sent: Saturday, October 7, 2006
Hi David
mysqldump is a command-line program which you can run through the
terminal window. The "Terminal" application is in the "Utilities"
directory under the "Applications" directory. The unix command-line
interface is amazingly useful; even though it may seem a bit
intimidating at f
Thanks. Is this something I can do through phpMyAdmin? I'm not used to working
with MySQL directly and don't understand exactly what this command means:
shell> mysqldump [options] --all-databasesDoes "shell" mean I have to be
working in some sort of command line program?
Also, if I can't figure
At 04:00 PM 10/7/2006, you wrote:
I recently purchased a MacBook Pro laptop and hired someone to help me set
up Apache, PHP and MySQL on it. Now I want to import my database tables
from my PC. So my main question is this: Is there a quick, simple of
importing an entire database? If not, I figur
I'm creating a table using a Select statement and several of the columns
are mathematical expressions. Unfortunately MySQL 5.0 creates them as
Decimal and I don't need that much precision. Is there a way to force MySQL
to create these columns as float?
Example:
create table x1 select 123.1*2.
I recently purchased a MacBook Pro laptop and hired someone to help me set up
Apache, PHP and MySQL on it. Now I want to import my database tables from my
PC. So my main question is this:
Is there a quick, simple of importing an entire database?
If not, I figured I'd simply export each database
In the last episode (Oct 07), abhishek jain said:
> I wanted to know the size of the data stored in a row of a table.
> I mean is there something like "select size from table where x..."
If you mean something similar to totaling up the sizes reported by
DUMP(field) in Oracle, no. The best you can
Hi,
I wanted to know the size of the data stored in a row of a table.
I mean is there something like "select size from table where x..."
--
Regards
Abhishek Jain
On 10/7/06, Patrick Aljord <[EMAIL PROTECTED]> wrote:
thanx it works the trigger is created successfully but it has no
effect. here it is:
delimiter //
create trigger testref before insert on bookmarks
for each row
begin
if new.title like '%xxx%'
then
set new.id='xxx';
thanx it works the trigger is created successfully but it has no
effect. here it is:
delimiter //
create trigger testref before insert on bookmarks
for each row
begin
declare dummy char(2);
if new.title like '%xxx%'
then
set new.id='xxx';
end if;
end;
//create t
I meant the error is:
mysql> CREATE TRIGGER testref BEFORE INSERT ON bookmarks
-> FOR EACH ROW
-> BEGIN
-> IF NEW.title LIKE '%xxx%' THEN
-> SET NEW.id ='xxx';
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version f
Hi Patrick,
Patrick Aljord wrote:
I would like to prohibit the value 'xxx' on my column title, and if it
does contain the value I would like to create an exception by
assigning 'xxx' to the primary key id which is int(5).
This is what I do but I get an error on its creation so I guess it's
not
At 16:23 +0200 10/7/06, Patrick Aljord wrote:
I would like to prohibit the value 'xxx' on my column title, and if it
does contain the value I would like to create an exception by
assigning 'xxx' to the primary key id which is int(5).
This is what I do but I get an error on its creation so I gues
I would like to prohibit the value 'xxx' on my column title, and if it
does contain the value I would like to create an exception by
assigning 'xxx' to the primary key id which is int(5).
This is what I do but I get an error on its creation so I guess it's
not the right way:
CREATE TRIGGER testre
mos wrote:
I have a simple query in MySQL 5.0.24:
insert into table1 (col1) select distinct col1 from bigtable;
that will run for 1:14:18. Both tables are MyISAM and table1 was just
created with 2 columns and is empty.
The "select distinct col1 from bigtable" takes only 2 minutes to run
Hi,
Try,
> libexec/mysqld --verbose --help
for mysqld options with variables
or
>bin/mysqld_safe --verbose --help
for mysqld options
For instance I want only /etc/my.cnf read and skip reading of other default
file,
>./bin/mysqld_safe --defaults-file=/etc/my.cnf
Hope this will do good.
T
On Sat, 2006-10-07 at 13:55 +0800, Ow Mun Heng wrote:
> Hi,
>
> Anyone here familiar with sqsh?
> I'm trying to get bcp going here for replication between a MSSQL
> server(2000) to a MySQL server (5.0).
>
> Since I've not found any "decent" way to do the replication, I'm now
> using sqsh to do i
24 matches
Mail list logo
