Hello colleagues.
Hi,
How can I global lock a database?
Global means that no user/process should be able to access it; I want to
keep the database
in read only for a certain period, NOT ONLY for the current session.
Have a look to Grant and User Privileges.
You can create a read only user,
Hi,
j'ai le red hat 9 et j'ai télécharger mysql-3.23.58-pc-linux-i686.tar.gz
j'ai crée le repertoir /usr/local/src et j'ai fais
gunzip mysql-3.23.58-pc-linux-i686.tar.gz
tar xvf mysql-3.23.58-pc-linux-i686.tar.gz
cd mysql-3.23.58-pc-linux-i686
./configure --prefix=/usr/local/mysql
mais ca
Hi,
Have a look here :
http://www.mysql.com/doc/en/Windows_installation.html
Bye
David
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi list,
I'm trying to optimise a SELECT ... LIMIT query, perhaps i miss something
important and so, i'm asking your help :)
I'm using MySQL 4.0.15 under Linux.
Here's a test query :
mysql explain SELECT * FROM F4000 WHERE ReplyTo=8711465 ORDER BY Numero
LIMIT 234599,20;
Hi list,
I'm trying to optimise a SELECT ... LIMIT query, perhaps i miss something
important and so, i'm asking your help :)
I'm using MySQL 4.0.15 under Linux.
Here's a test query :
mysql explain SELECT * FROM F4000 WHERE ReplyTo=8711465 ORDER BY Numero
LIMIT 234599,20;
From: Willy Dockx [EMAIL PROTECTED]
Sent: Monday, January 05, 2004 7:23 PM
Subject: RE: French characters ok with mysql in Windows, nok with mysql in
Linux
Hello,
etc/sysconfig/i18n contains:
LANG=en_US.UTF-8
SUPPORTED=nl_BE.UTF-8:nl_BE:nl:en_US.UTF-8:en_US:en
SYSFONT=latarcyrheb-sun16
From: Willy Dockx [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, January 05, 2004 3:00 PM
Subject: French characters ok with mysql in Windows, nok with mysql in Linux
Hello,
I already posted this problem end of 2003, but probably, the champagne has
troubled the answers.
The solution
Hi list,
I've got a small MyISAM table which is used for some statistics.
I'm only doing insert into this table.
I need that clients doing INSERT queries can exit as soon as possible.
So, i'm using INSERT DELAYED with some good succes.
But I've got a question.
If i decrease delayed_insert_limit
So, i'm using INSERT DELAYED with some good succes.
But I've got a question.
If i decrease delayed_insert_limit to ten secondes for example, is that
mean
that delayed_queue will be flushed every ten secondes ?
Is there an other variable that specify the flush time ?
No -
Tuesday, December 09, 2003 2:51 PM
Chris Elsworth wrote:
If you increase delayed_insert_limit then you're effectively giving
the DELAYED thread more preferencee to the table; it will write more
rows (once it can, ie there's a phase of time where there's no locks
on the table) in a batch,
Hi list,
I think i've found a little bug in MySQL 4.0.15
(mysql-standard-4.0.15-pc-linux-i686.tar.gz)
Description :
Here's my error log :
Warning: thr_alarm queue is full
Warning: thr_alarm queue is full
[...]
How To Repeat :
Here's my conf file :
[client]
port= 3306
socket
Hi list,
I've just a crazy problem with Mysql 4.0.15
(mysql-standard-4.0.15-pc-linux-i686.tar.gz).
I have 2 user, root and Dstats.
With root, i can do all i want (create database, create table ...).
With Dstats i can't create table in a database.
My Grant :
grant all privileges on
Can you create a repeatable test case ?
Regards,
Sergei
On the server where i've got problem, I tried making a dump and import dump
into a table with same name but into a different database.
There it works ...
So, i come back to my production database and table.
I've always got the same
Hi list,
I've got a little bug with MySQL.
I can insert a row into my table but this row will not appear in the table
:(
Server is under linux redhat, MySQL is 3.23.56 installed from binary
tar.gz
from MySQL team.
Table Description :
mysql desc Log_Forums;
Hi,
I don't know if it has anything to do with your problem, I just wanted to
comment on the use of a timestamp column in a primary key...
* David Bordas
+--+--+--+-+-+
+
| Field| Type | Null
Hi,
mysql select * from Log_Forums where Date=2003080611;
mysql insert into Log_Forums (pseudo,date,Type_Message) values
(doss08,2003080611,0);
insert into Log_Forums (pseudo,date,Type_Message) values
(doss08,2003080611,0);
Same thing here.
But i solve my problem by update
Hi!
Currently, I'm running 3.23.51 on Red Hat 7.1, and I'm contemplating
upgrading to MySQL 4.0, but I'm not sure what to expect. I don't know if
MySQL 4.0 is fully backwards-compatible with 3.23.x versions, or if
something is going to break if I upgrade.
What are the main advantages of
Hi list,
I've got a little bug with MySQL.
I can insert a row into my table but this row will not appear in the table
:(
Server is under linux redhat, MySQL is 3.23.56 installed from binary tar.gz
from MySQL team.
Table Description :
mysql desc Log_Forums;
Hi,
I'm using GNU/Linux Slackware 8.0 and not using any my.cnf (so the
configs are all at default).. Is it possible that mysql is doing some
background tasks while the system is in idle state ?
Which MySQL version did you use ?
Some old mysql binary were compiled with wrong glibc and have this
Here's an example of how much data could be stored in a year:
1 value/minute are stored = 1440 values/day.
365 days / year.
We have 100 different tables with 25 columns each.
This makes 100*25*365*1440 = 1 314 000 000 values per year.
A typical value could be 25,5624.
How much space (in Mb)
Hi list,
I've a question about the database privilege and the Mysql.db table.
If i do something like this : GRANT SELECT ON MYDB.* TO [EMAIL PROTECTED];
( i'm using MyISAM tables ... )
And if MYDB contains something like 100 tables, could this make me problems
?
In fact, i have errors like this
Hi list and thanks to read me.
Since december, I've got aborted_clients and aborted_connects to my mysql
server ...
Clients that connected to this server have errors like :
Failed to connect to database:
Error: Access denied for user: '[EMAIL PROTECTED]' to database 'mydb'
MySQL server has gone
Hi,
Was found problems with some glibc system, please use temporally the
work around of the start the server with the option:
--thread_stack=196KB
Ok i'll have a look to that.
For the glibc, i used binary tar.gz, so even if my glibc is buggy this'll
not affect me ...
The access denied is
Anybody else who has any idea why the index are not used as they should?
I've got same things with 3.23.xx and select query through a TCP/IP
connection.
I don't know why, but you can solve this issue using the USE INDEX syntax
for select queries ...
http://www.mysql.com/doc/en/SELECT.html
Hi all,
I've some problem with my Mysql servers since the beginning of last week :(
I've upgrade mysql from 3.23.53a to 3.23.54a and i still have same errors :(
I've got plenty of error like this :
Failed to connect to database: Error: Access denied for user:
´[EMAIL PROTECTED]´ to database
hi,
I always have my problem and i didn't find any solution pour the moment.
Please, if somone have an idea ... :(
Thanks
David
Subject: [Error] Mysql server has gone away 3.23.53a
Date: Thu, 19 Dec 2002 17:23:31 +0100
I've some problem with my Mysql servers since the beginning of this week.
Hi all,
I've some problem with my Mysql servers since the beginning of this week.
I've got plenty of error like this :
Failed to connect to database: Error: Access denied for user:
´[EMAIL PROTECTED]´ to database ´DB1´
MySQL server has gone away
Error Nø1, please contact webmaster ...
In fact,
I have the following query. When executed in MySQL I get an error on the
first sub-select, and I can't find why:
http://www.mysql.com/doc/en/News-4.1.x.html
You'll see that sub-select query will be in future 4.1.xx release ...
David
Hello,
I upgrade my server from Mandrake 8.2 to Mandrake 9.0 and i have a little
problem with MySql 3.23 (Ver 3.23.52 for pc-linux-gnu on i686):
When i try to start MySQL with this command with root user :
# safe_mysqld --user=mysql
I obtains the following response:
# Starting mysqld
Have a look to the mysql error log to see if you can find your problem
...
This file should be in /usr/local/mysql/data
I have no log file, the only file created is serveur name.err with the
number of the thread who crash.
touch13
This file IS the mysql error log.
On one of mine i can see
I wish to tune our MySQL Server Parameter to increase
the speed of Join. I was trying to do a simple join
with two tables. One is big (~2,500,000 records); the
other one is small. The current join seems to take
forever to finish even on the indexed attribute.
I am trying to learn from
How can i extract names of columns from table? I am doing select *
from table, then i want to get name of columnsis it possible?
Use desc or describe.
http://www.mysql.com/doc/en/DESCRIBE.html
David
-
Before posting,
Hi All,
What's wrong if this error message appears when I try to run mysql:
cannot connect to local Mysql server through socket
'/var/lib/mysql/mysql.sock'
If I run mysql_config, this appears:
--socket /tmp/mysql.sock
What should I do to correct this? Thanks.
Modify your my.cnf file
Could someone tell me where the logs are written to by default, for a 3.23
install of MySQL on Linux?
I looked in /usr/share/mysql/english and each directory leading up to it,
but I didn't see anything resembling a log file.
Thanks.
Neal
Logs are in your data directory with the Tables
This problem is due to the glibc used by mysql AB for building binary ...
Have a look to mysql 3.23.53 change log :
We've hopefully fixed the problem with spurious load spikes on Linux
systems when accessing the Database via TCP/IP. This was caused by
the
static glibc files we used to
MR We run MySQL on a 2xP3 1Ghz (Coppermine), 1 GB RAM, 1 software RAID1 (2
x
MR SCSI), Linux 2.4.9-31 (RedHat patched kernel). We have run a older
version
MR of MySQL (we run only binary releases) for a long time (6 months) with
MR great success. We had uptimes like 100 days and almost 200
DB I found my problem and why Mysql lock my table for a select. In
DB fact, mysql sometimes don't use the right index and so does a 'Table
DB sort' that lock my table. I modify the query to add USE INDEX
DB clause and now, all seems to work well ... I just need to test
DB during several days
Hi list,
I've just a little question for the end.
I planned to have around 10K tables under a DB and this number surelly grow
up to 20K.
I know that a database is a directory and a table is 3 files.
I just want to know is mysql have a limit in the number of table per
database.
If not, i know
Hi,
I use mysql 3.23.4 max on linux and it have worked just fine.
Now I want to use Transactions so I thougt that I should use the my.cnf to
configure for that.
Trouble is there is no my.cnf file on my computer.
Do I have to create the file myself ?
or is the InnoDB settings configured right by
DBI still have performance problem with my big MyISAM table.
DBIn fact, mysql keep locking my table, even for doing select :(
PDB That's how MyISAM works -- it uses table locks for everything.
PDB Given that fact, if it didn't lock the table for reading, that would
PDB allow other clients to
Hi list,
I still have performance problem with my big MyISAM table.
In fact, mysql keep locking my table, even for doing select :(
I don't know why but it's very very annoying.
1% of my query are search ones.
Theses queries are slow, too slow.
So i'm thinking about splitting my table to lot of
Hi all,
Just a little question on the MyISAM table lock implementation ...
I just see ( with show full processlist ) that my version of mysql ( 3.23.45
binary linux tar.gz ) locked my MyISAM table at every query and not only for
update / delete / insert.
Why is it locking table for select query
Hi,
I have written previous websites where I used perl or PHP
to access a Mysql DB wen bith the webserver and the Mysql
db are on the same server.
My questions is how different is it to access or connect
to the Mysql database when the database is on a separate
server(machine)?
Juste
From: borracho 138 [EMAIL PROTECTED]
I've searched for more information on these issues, without luck.
The system randomly spirals out of control - load avg increases very
rapidly, resulting in loads of 200-300 in 2/3 minutes. At other times the
server is fine, handling the busiest loads.
From: borracho 138 [EMAIL PROTECTED]
Many thanks for the reply - nice to know that I'm not the only one with
this
issue(!)
Seems like my problem is related to 2 areas:
- I'm concerned about the lack of memory 'freeing' with the system, but a
kernel upgrade may fix that
Don't have this
BS Have you tried the command : EXPLAIN SELECT select_options
BS (http://www.mysql.com/doc/en/EXPLAIN.html). Maybe it can help you to see
BS what Indexes are used ...
Yep i do that but varchar and text fields aren't index so ...
I'm also having a look to FULLTEXT index, but i think that the
From: Shashank Tripathi [EMAIL PROTECTED]
This will be fast if you have the right index--
field5 like 'John%'
These will NOT be fast --
field5 like '%John%'
field5 like '%John'
Putting a wildcard character (%) before the term will avoid the index.
Yep, and it's for that point that
From: Shashank Tripathi [EMAIL PROTECTED]
| Why not regexp but this is not i mean, in fact
| where CONTENT like '%word1%'
| or CONTENT like '%word2%'
| or CONTENT like '%word3%'
| shoud be :
| where CONTENT1
Hi all,
I've discovered that we have a select query that blocked all others query to
this table.
99% of query used indexs, no join ...
But this one is a problem :
SELECT Field1,Field2,Field3,Field4,Field5,Field6,Field7 FROM MyTable WHERE
Field7=15 AND Field2=0 AND (Field3 LIKE '%John%' OR
ME As first step, try to optimize table with help of
ME OPTIMIZE TABLE MyTable
ME command.
ME Any progress?
Already done something like optimize :
myisamchk -v -a -S --sort-records=1 ../data/jeuxvideo/MyTable
David
sql,query
DB Already done something like optimize :
DB myisamchk -v -a -S --sort-records=1 ../data/jeuxvideo/MyTable
ME And? No result?
Some good result but nothing enough good :(
I'll have a look to fulltext search, perhaps i'll find something good.
I know that fulltext search only search for full word
From: Franz, Fa. PostDirekt MA [EMAIL PROTECTED]
KF an Index wouldnt help much , because of the 'LIKE %... '.
KF If a wildcart is at the beginning of the search-string , an Index
KF cannot help much.
Ok as i thought, index text field is a bad thing ...
KF You have to think about why are there
From: Andrew Izsof [EMAIL PROTECTED]
DB I know that '(Field3 LIKE '%John%' OR Field4 LIKE '%John%' OR Field5
LIKE
DB '%John')' part is the problem.
AI The formula : '%John%' always sweeps through all of the records, because
it
AI can't utilize any indexes, sorting, etc. But if you leave the
From: Mikhail Entaltsev [EMAIL PROTECTED]
ME Check the query plan
ME EXPLAIN SELECT Field1,Field2,Field3,Field4,Field5,Field6,Field7 FROM
ME MyTable WHERE
ME Field7=15 AND Field2=0 AND (Field3 LIKE '%John%' OR Field4 LIKE '%John%'
OR
ME Field5 LIKE '%John') ORDER BY Field6 LIMIT 0,20;
| table
- Original Message -
From: Mikhail Entaltsev [EMAIL PROTECTED]
ME Can you send result of the query, please:
ME select * from MyTable PROCEDURE ANALYSE();
Here you are :
mysql select * from MyTable PROCEDURE ANALYSE();
- Original Message -
From: Dicky Wahyu Purnomo [EMAIL PROTECTED]
DB SELECT Field1,Field2,Field3,Field4,Field5,Field6,Field7 FROM MyTable
WHERE
DB Field7=15 AND Field2=0 AND (Field3 LIKE '%John%' OR Field4 LIKE '%John%'
OR
DB Field5 LIKE '%John') ORDER BY Field6 LIMIT 0,20;
DWP have you
From: Mikhail Entaltsev [EMAIL PROTECTED]
ME IMHO the problem is in this condition
ME ...Field5 LIKE '%John'...
ME Can you remove it from query and try again?
In fact it was Field5 LIKE '%John%',
but Field5 LIKE '%John' and Field5 LIKE '%John%' don't change query
speed at all except about
From: Mikhail Entaltsev [EMAIL PROTECTED]
As I understand...
After removing Field5 LIKE '%John' condition the query works much
faster.
Nop, sorry i'm not clear, the query works mush slower ...
But it is different query... :)
I mean that queries return different results.
Yep ...
On other
ME In this case...
ME Can you try again?
Sure.
query 1 :
SELECT Field1,Field2,Field3,Field4,Field5,Field6,Field7 FROM MyTable
WHERE
Field7=15 AND Field2=0 AND (Field3 LIKE '%John%' OR Field4 LIKE '%John%'
OR Field5 LIKE
'% John%' ) ORDER BY Field6 LIMIT 0,20;
query 2:
SELECT
Config for us :
Linux Red-Hat
Kernel 2.4.7-10smp #1 SMP
Dual intel PIII
1 GB RAM
The problem occurs with these versions :
mysql-3.23.51-pc-linux-gnu-i686.tar.gz
and
mysql-3.23.52-pc-linux-gnu-i686.tar.gz
Cordialement
David BORDAS / JEUXVIDEO.COM
Victoria
Monday, August 19, 2002 11:58 AM, you wrote :
VR Hi, David!
VR You can find new 3.23.52 binary packages at www.mysql.com
VR Could you install new packages and check if loading problem occurs
VR again?
One of our production server is running 3.23.52 ( the tar.gz one ).
Uptime is 26
David,
Thursday, August 22, 2002, 9:48:14 AM, you wrote:
DB Victoria
DB Monday, August 19, 2002 11:58 AM, you wrote :
VR Hi, David!
VR You can find new 3.23.52 binary packages at www.mysql.com
VR Could you install new packages and check if loading problem occurs
VR again?
DB One of
IK hi list
IK Can I also execute mysql commands from the shell.
IK Something like this:
IK % mysql -u root -pmypass --execute=use mydb; select * from mytable;
You can do something like this i think :
% mysql -u root -pmypass mydb --execute='select * from mytable'
David
Hi list,
I've just a tiny question.
I used mysql 3.23.49 linux binary package but i've got some problems with
it.
I should upgrade quite shortly because 3.23.49 binary package is buggy
... ).
We have load problems, memory eating ...
But i can't use mysql 3.23.51 binary package.
( see Re:
Hi,
perhaps Mytop will be good for you ...
http://jeremy.zawodny.com/mysql/mytop/
David
- Original Message -
From: Lasse Laursen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 16, 2002 10:56 AM
Subject: Performance Monitoring/Counters
Hi all,
Which tools would you
Hi list,
Same thing here, mysql 3.23.51 works well during about 2 hours then
suddently load average grow up to 200 and more ...
Load average is less than 4 with 3.23.49.
We're using binary tar.gz non max versions from Mysql.com
OS : Linux Red hat 7.2
kernel : 2.4.10
1 Go RAM
2 * Intel 1 Ghz
Hi list,
Same thing here, mysql 3.23.51 works well during about 2 hours then
suddently load average grow up to 200 and more ...
Load average is less than 4 with 3.23.49.
We're using binary tar.gz non max versions from Mysql.com
OS : Linux Red hat 7.2
kernel : 2.4.10
1 Go RAM
2 * Intel 1 Ghz
Hi list,
I've got lots of troubles with one of my mysql dedicated server.
The problem occurs time to time ( during peac or idle time ).
In fact mysql seem not to answer all connections.
Netstat show several connections TIME_WAIT and show process_list only show
1 ou 2 queries running ...
But on
|
| Uptime | 132998 |
+--++
111 rows in set (0.00 sec)
Thanks
David
- Original Message -
From: David BORDAS [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 03, 2002 7:03 PM
Subject: TCP TIME_WAIT strange
Hi list,
just have this when connecting to my mysql dedicated server :(
The server is like this :
bi PIII 1 Ghz
1Go of ram
Raid 5 scsi hdds
Here is a tail of the error log :
020619 08:03:09 mysqld started
/usr/local/mysql/bin/mysqld: ready for connections
The system don't swap.
Using Linux
Hi list,
just a tiny question, i use mysql 3.23.51 ( tar.gz binary ) under linux.
All is fine, mysql is started without a problem ...
020618 14:28:04 mysqld started
/usr/local/mysql-3.23.51/bin/mysqld: ready for connections
I can see in /usr/local/mysql-3.23.51 some files like :
Hi list,
I've got a mysql dedicated server.
Some piece of hardware :
SMP : 2 * Intel PIII 1 Ghz
1Go of ram
Scsi - Raid 5 Hdds
Linux red-hat 7.2
This system run mysql 3.23.49 (tar.gz binary from Mysql.com ).
I only have one MyIsam table with around 5 Millions of records ( around 1.2
Go disk
Have a look to mysql error log located in /usr/local/mysql/data
David
- Original Message -
From: Paul [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, June 04, 2002 12:15 PM
Subject: can't start mysql.server
hi,
my machine is compaq alphastation DS20E, and the mysql verision
Hi,
Just connect to mysql and use this query :
show processlit;
http://www.mysql.com/doc/S/H/SHOW_PROCESSLIST.html
You can also use slow query logs.
http://www.mysql.com/doc/S/l/Slow_query_log.html
David
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday,
Think that even if mysql don't have connection, there are severals processes
running ...
For waiting connection for exemple.
with 11.5 Mgs or so
This memory is i think a buffer or a cache shared by each mysql process such
as indexes for exemple ...
David
From: [EMAIL PROTECTED]
To: Sergey S.
I think you'll find some usefull infos here :
http://www.mysql.com/documentation/mysql/bychapter/manual_News.html#News-3.2
3.x
Just one thing : 3.23.50 tar.gz and rpm is little different because Mysql
team used a newer gcc version ...
Bye
David
- Original Message -
From: Inbal Ovadia
Hi list,
i know that 3.23.50 is a pre-released version. But if someone can tell me
when this version will be declared as stable so i will upgrade my linux
production servers running redhat 7.2 and gcc 2.96 with the tar.gz build
mysql.
Thanks
David
filter : sql,query
SMP is System Multi Processor
Like a server with 2 or more CPUs ...
David
- Original Message -
From: webmaster [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, May 13, 2002 1:07 PM
Subject: Re: Re: mysql uses 99% cpu under freebsd 4.3
So far I've experienced it on one SMP box
- Original Message -
From: Harpreet Kaur [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 23, 2002 5:44 PM
Subject: mysqldump
Dear group members
I did a mysqldump on my machine at home to backup a database. I saved the
file to the /home/backup folder at my work and am
- Original Message -
From: MySQL Newsgroup @[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, April 19, 2002 2:55 PM
Subject: Re: Select with Order By that don't use my INDEX :(
Subject: Re: Select with Order By that don't use my INDEX :(
From: Vic Cekvenich [EMAIL
I'm using mysql 3.23.49 on Linux redhat dedicated server.
Here is my query :
mysql show index from MyTable;
Table: MyTable
Non_unique : 0
Key_name: PRIMARY
Seq_in_index: 1
Column_name : Field0
Collation : A
Cardinality
- Original Message -
From: Joseph Bueno [EMAIL PROTECTED]
To: David BORDAS [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, April 19, 2002 10:34 AM
Subject: Re: Select with Order By that don't use my INDEX :(
David BORDAS a écrit :
I'm using mysql 3.23.49 on Linux redhat
Hi,
i'd like to alter a table which have a date and time field so 3 Bytes for
date and 3 Bytes for time.
I'd table to add a new field to store date like this : MMDDHHMMSS.
In fact, I can't use indexes on sql query like select with order by with 2
fields date + time and with
one unique field
Sent: Tuesday, April 09, 2002 2:14 PM
Subject: Re: TIMESTAMP(14) or Bigint ??
David,
I could be wrong but since bigint isn't a date or time oriented data
type I imagine this would be completely useless to you unless you are
storing unix timestamps.
In fact i'm looking to a way to store
Sent: Tuesday, April 09, 2002 2:14 PM
Subject: Re: TIMESTAMP(14) or Bigint ??
David,
I could be wrong but since bigint isn't a date or time oriented data
type I imagine this would be completely useless to you unless you are
storing unix timestamps.
In fact i'm looking to a way to store
Yes but in fact i forgot to say that i have to change a value of a column,
Ex dump all data from table where category = 2 and
insert all this data into the other mysql with category = 4 and not 2
I think with too connection
i can select all data then insert in new server
ben delete on the old
86 matches
Mail list logo