What have people done in the past regarding backup strategies?
Is it adequate enough to rely on filesystem backups for mysql? Basically
such that we can restore MySQL to the last filesystem backup. Is there a
reason not to do this?
I don't have any mission critical data and data that is lost si
Dear friends,
This is my first cpp module working with mySQL.
It looks like the error is located in
MYSQL *m=mysql_real_connect(myDB, host, user, passwd, ...
There is a way to find out step by step which parameters is wrong?
I am working with Fedora core 3
and MySQL 3.23.58
Thanks,
MT
+++
Hello,
I have a database (on Win2k) with merge table. Mysqldump output includes
some path information on the merged tables such as DATA DIRECTORY and
INDEX DIRECTORY
DROP TABLE IF EXISTS `rptpricing1996`;
CREATE TABLE `rptpricing1996` (
`PricingId` int(11) NOT NULL default '0',
`commodity`
Hi Stony,
I didn't use PostgreSQL before, so couldn't comment. For MySQL, you have
to beware of the following:
- Store procedure, views, triggers is supported only in version 5, which
is still in development phase.
- clustering / failover feature is only out for about 9 months, so the
stability
How do you think about PostgreSQL and mysql? want to know which is good? How to
choose database for the web?
Hi,
you may use somethinh lik ethis :
$dbh->do("SET character_set_results="ujis"');
look at http://dev.mysql.com/doc/mysql/en/charset-general.html
Hope that helps
Mathias
Selon Gleb Paharenko <[EMAIL PROTECTED]>:
> Hello.
>
>
> What do your 'show' statements return when you execute them from t
Hello.
What 'SHOW WARNINGS' reports?
Elizabeth Bonifacio <[EMAIL PROTECTED]> wrote:
> Dear Gleb,
>
> Thanks, i will try that as well, so far my program can access the
> server now by using the old password. Now my problem is when i load
> file, its only reading the first line and some
Hello.
Read:
http://dev.mysql.com/doc/mysql/en/upgrade.html
http://dev.mysql.com/doc/mysql/en/multiple-servers.html
And search in archives about possible troubleshooting:
http://lists.mysql.com/mysql/
mm <[EMAIL PROTECTED]> wrote:
>
> I have on my system, Fedora core
Hello.
What do your 'show' statements return when you execute them from the
perl script?
Batara Kesuma <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I just moved my DB from 4.0 to 4.1.11. I used mysqldump to dump the data
> first, and then inserted it to the new DB. The character set of th
Hello.
First read:
http://dev.mysql.com/doc/mysql/en/charset.html
"Roberto Jobet" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm using MySQL
> 4.1.11
>
> I need to setup a
> multilingual
> databa=
> se to support
> a lot of foreign
> languages.
>
> Do I have to setup a
> U
Hello.
It seems like a documented bug. Switch to 4.1.12. See:
http://dev.mysql.com/doc/mysql/en/replication-features.html
Markus Benning <[EMAIL PROTECTED]> wrote:
> Hello,
>
> i have a problem with my replication setup and SET statments.
> The SET statments seem to be not logge
Hello.
Complete and rich character set support appeared only
in MySQL 4.1. So if it is possible move to 4.1.
Andrew Mull <[EMAIL PROTECTED]> wrote:
> Hello,
>
> We are running mySQL 3.23.58 on a RedHat server. We have a database
> that needs to store Chinese (big5) and Vietnamese (U
Hello.
What is in MySQL error log? Did you use InnoDB tables?
Alla-amin <[EMAIL PROTECTED]> wrote:
> Hi everyone,
>
> I just subscribed to the list and some of the articles
> are very helpful. I'm facing some problem on my mysql
> database server.
>
> One of our Raid drives crash
Hello.
It is a FAQ. Use -U. Search in archives at:
http://lists.mysql.com/mysql
about possible problems.
Eldon Ziegler <[EMAIL PROTECTED]> wrote:
> I'm trying to upgrade a "factory" installed 3.23.58 to 4.0 and then 4.1.
>
> rpm -i MySQL-server-4.0.24-0.i386.rpm results in
>
Hello.
Do you have a shell account on that server? Are you
allowed to connect to your server from remote machines (ask support of your
hosting about this).
"Badr Al-Muzini" <[EMAIL PROTECTED]> wrote:
> hi,
> i try to access the MySQL server remotely using Command prompet how can i do
Hello.
I don't know any SQL statements which could launch extern commands,
at least in MySQL. So in triggers it is impossible as well.
Ted Zeng <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am using MySql on Mac OS X.
>
> I am wondering if I could execute a command (shell, perl) by a Tr
Hello.
Compiling MySQL on some systems could be a hard task.
Please give us more information about what you're doing
and your building environment. Have you tried GNU make?
"Simon Tierney" <[EMAIL PROTECTED]> wrote:
> Can anyone advise please, tried binary installation but other users ha
Hello.
Use the latest release (4.1.12 now). Have you tried to connect using
the root account?
"Ron Day" <[EMAIL PROTECTED]> wrote:
> After I installed mysql 4.0.18 on Windows XP I could not use it.
>
> It seems the mysql database does not show up. I looked in the data directory
> an
You can't transfer database files directly between versions. The file
format is different. You need to dump the data to a text file and
import it.
This isn't like FileMaker, Word or Excel where it will realize it's an
older version and convert it.
On Jun 24, 2005, at 9:42 AM, Alla-amin wrote
Ashok Kumar wrote:
Hi friends,
I'm now started to using the Redhat-Linux. Now i want
to start MySQL on Linux. I'm not having much idea
about Linux. I'm new to this. For Linux which MySQL
installation i've to choose from the site. there are
lot of binary distributions, i don't which one is
compat
Hi friends,
I'm now started to using the Redhat-Linux. Now i want
to start MySQL on Linux. I'm not having much idea
about Linux. I'm new to this. For Linux which MySQL
installation i've to choose from the site. there are
lot of binary distributions, i don't which one is
compatible for my OS.
Lin
u might want to check the permissions in the data directory, may be
the user under which mysql runs does not have the proper permissions
on the databases..
Kishore Jalleda
On 6/24/05, Ron Day <[EMAIL PROTECTED]> wrote:
> After I installed mysql 4.0.18 on Windows XP I could not use it.
>
> It see
After I installed mysql 4.0.18 on Windows XP I could not use it.
It seems the mysql database does not show up. I looked in the data directory
and it is there, but if I do a show databases from the mysql client only the
test database shows up.
any thing else I try causes errors.
any ideasI be
I'm trying to upgrade a "factory" installed 3.23.58 to 4.0 and then 4.1.
rpm -i MySQL-server-4.0.24-0.i386.rpm results in
error: Failed dependencies:
MySQL conflicts with mysql-3.23.58-16.FC2.1
MySQL-server conflicts with mysql-server-3.23.58-16.FC2.1
How do I get the install to work?
Thank
> If I remember right, the R-TREES are associated with the GIS extensions to
> MySQL. I could be wrong but that's how I remember it (and I had a hard
> time finding a reference to them in the official online manual. Can anyone
> help?)
>From what I've been able to dig up, this is correct. I was h
Yes You can have both versions, infact this is the preferred way to
upgrade, but the only thing is that have the new version install in
/usr/local/mysql2/ or what ever you want and change the port that the
newer daemon listens on instead of the default 3306, here's a good
link from the doc's of mys
Most of MySQL commands have "--host" option that allows you to address
remote MySQL server.
One needs:
* To have MySQL server be running on all machines you want to "reach"
* Each remote host must allow remote users, from your hosting server, to
execute commands on that server.
-Original Mess
hi,
i try to access the MySQL server remotely using Command prompet how can i do
so? i mean i want to run all MySQL command on my hosting server
...
_
Dont just search. Find. Check out the new MSN Search!
http://sear
On Jun 24, 2005, at 10:56 AM, Markus Benning wrote:
i have a problem with my replication setup and SET statments.
The SET statments seem to be not logged with the queries.
This is a replication limitation in versions prior to 4.1:
Update statements that refer to user variables (that is, varia
"Rob McDonald" <[EMAIL PROTECTED]> wrote on 06/24/2005 10:37:39 AM:
> I'm running MySQL 4.0.18-nt & accessing the database primarily through
Java
> with MySQL/Connector J (similar vintage). I am administering this
myself,
> and can upgrade as needed. I know I'm a bit behind the times.
> I apo
Hello,
i have a problem with my replication setup and SET statments.
The SET statments seem to be not logged with the queries.
An example:
CREATE TABLE blablub (ID INT NOT NULL auto_increment PRIMARY KEY, bla text,
blub text);
SET @bla='bla';
SET @blub='blub';
INSERT INTO blablub VALUES(NULL, @
Hi,
I just moved my DB from 4.0 to 4.1.11. I used mysqldump to dump the data
first, and then inserted it to the new DB. The character set of the data
is EUC-JP (ujis).
My problem is, I can see the character correctly if I connect to mysql
server using mysql client. For example:
# mysql -e "SELEC
I'm running MySQL 4.0.18-nt & accessing the database primarily through Java
with MySQL/Connector J (similar vintage). I am administering this myself,
and can upgrade as needed. I know I'm a bit behind the times.
I apologize for a bit of background, skip to the end for the question
I am usin
Sajith A <[EMAIL PROTECTED]> wrote on 06/24/2005 02:07:22 AM:
> Thank you Mathias once again
> > I suggest you to test after optimize table ... and analyze table ...
> > if you stay with the problem and you can give me a set of data,
> i'll try to help
> > more.
> Initially while posting... i
Alla-amin wrote:
Yes, 10.1.5 runs mysqk version 3, it was actually
running 3.23.51 and 10.3 runs 4.0.14 I think. Ok - the
database in question have been backedup with files
such as
table1.frm.gz
table1.MYD.gz
table1.MYI.gz
and so on.gz
When I create a new database on the new server and
copy the
Yes, 10.1.5 runs mysqk version 3, it was actually
running 3.23.51 and 10.3 runs 4.0.14 I think. Ok - the
database in question have been backedup with files
such as
table1.frm.gz
table1.MYD.gz
table1.MYI.gz
and so on.gz
When I create a new database on the new server and
copy these files to the the
Sajith A wrote:
Thank you Clark for your time
Try using straight joins to force MySQL to join from qb_test_result first.
The order chosen by the optimizer has no use for keys from this table.
I tried to force indexes.. but it didn't help
Thank you
Since the query you supplied cann
I have to ask, are you using the same version of MySQL? I think 10.1
came with v3 and 10.3 come with v4.0.
You may need to setup 10.1.5 on an old machine to dump the database for
importing.
On Jun 23, 2005, at 4:53 PM, Alla-amin wrote:
Hi everyone,
I just subscribed to the list and some of
Hi,
I'm using MySQL
4.1.11
I need to setup a
multilingual
database to support
a lot of foreign
languages.
Do I have to setup a
UTF-8 unicode
database ?
Does anyone have a
step-by-step guide
on how to achieve
this ?
Thanks for any help
Regards
Roberto
__
hi,
if u'r uninstalled the mysql and try to reinstalling
means, try the following.
1.Delete all the corresponding files that are created
by the prev installation after the uninstallation.
2.Install the MySQL again. Now it'll work.
This is due to some configuration prob between the
prev and new
Dear Friends,
Iam trying to install MySQL 4.1.2 in Windows 2003 Server, and on error occurs
when installation try a start de service. The service does not start and
installation don't finish.
I Need a help about it.
Regards for all.
--
MySQL General Mailing List
For list archives: http://l
I have on my system, Fedora core 3, MySql 3.23.58
Working with wikipedia database I get one error an one advise to upgrade
to Mysql 4.xx
Can I have old mySQL and the new one on my system?
It is necessary to recreate databases and reload the data?
What other kind of problem is suppose to find o
Dear Gleb,
Thanks, i will try that as well, so far my program can access the
server now by using the old password. Now my problem is when i load
file, its only reading the first line and some more insert a null
record before the ist record.
here is the result i get after loading the text file:
my
43 matches
Mail list logo
