Ivan Levchenko wrote:
Hi All,
What would be the best way to transfer a 20 gig db from one host to another?
mysqldump -A > file.dump
tar -jcf file.dump
rsync
or use replication to do it (might take a bit longer this way though).
--
MySQL General Mailing List
For list archives: http://lists.my
Hi,
If you have 256Kbps should not be a problem as long as it used most for
mysql, if there are too may other user accessing net then it would be too
slow.
When you say, you want to access from both the sites, does it mean there
would be read and write from both sites or just read from from one si
I have a column in a table that was turned into an cp1251_general_ci
for a type of encryption. Question is, how do I unencrypt it?
Thanks
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Do you have the latest version of DBI and DBD::mysql installed?
First try:
$ cpan
cpan> install DBI
cpan> install DBD::mysql
You can also do:
my $sth = $dbh->prepare("select last_insert_id()");
$sth->execute();
my ($last_insert_id) = $sth->fetchrow_array();
Octavian
- Original Message --
Hi,
I know that someone is going to say, "go ask the perl module guys" and
I will but they are likely to say, "go ask the MySQL guys". I'll be
asking in both groups.
I am installing a script on a brand new RedHat, Fedora Core 7 (x86_64)
box that is running MySQL 5.0.45 (rpm install). I also hav
Malki,
>which gives the error:
>ERROR 1054 (42S22): Unknown column 'depts.dept_code' in 'on clause'
See the JOINs page of the manual. As of 5.0.12, MySQL improved ISO SQL
compliance in query parsing; ambiguities due to comma join syntax became
errors. It's highly recommended to switch from com
Hi,
Option 2 will not work. InnoDB has background threads that continue
to change data even when the database is "quiet".
This is a simplification. The details are too complicated to write in
this thread, but there's an entire chapter on this topic in the book
I'm writing right now, High Perfor
Hello,
I am using MySQL in a booking system I am working on. I decided to use an
embedded server so downloaded 5.0.45 from source and compiled it with the
embedded library enabled.
It works fine except that disconnecting seems to take an exceptionally
long time. Relevant lines from the log file
Hi,
On Jan 28, 2008 5:31 AM, <[EMAIL PROTECTED]> wrote:
> We have just moved to a new machine where we are running MySQL 5.0.45. On
> the old machine we were running MySQL 4.0.15a.
> The following query worked in 4.0.15a but gives an error mesage in 5.0.45.
> We're pretty sure the problem is with
Hi Alex,
I've used this method to start a replication slave without using MySQLdump to
get the data from one machine to another.
Option 1 works for sure,
Options 3 and 4 do not work for sure (if a .MYI, .MYD or ibdatax file is
changed while you are copying, you get a broken file on the other en
Hi guys,
Is it safe to perform a backup of a database by copying its mysql
files if the database is:
1) MyISAM and the database is not being used (mysql server turned off)?
2) InnoDB and and the database is not being used?
3) MyISAM and the database is being used?
4) InnoDB and and the databas
We have just moved to a new machine where we are running MySQL 5.0.45. On
the old machine we were running MySQL 4.0.15a.
The following query worked in 4.0.15a but gives an error mesage in 5.0.45.
We're pretty sure the problem is with the left join. Did anything change?
Here's the query:
select
12 matches
Mail list logo
