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
Krishna Chandra Prajapati schrieb:
> Hi All,
>
> The production server on which mysql database was running, get
> shutdown on one day. Then we have to manually start it. The server is
> hpdl585. What can be the reason of shutdown. What has gone wrong with the
> server. Is there is any to find the
please notify
the sender immediately by telephone or email and destroy the original
message without making a copy. Thank you.
- Original Message -
From: "Richard" <[EMAIL PROTECTED]>
To: "C K" <[EMAIL PROTECTED]>;
Sent: Sunday, August 05, 2007 4:01 AM
Subject:
Sorry maybe this is completly out of topic, but why do you need it to
synchronise in two locations, can't you just get both servers to connect
to the same database?
And then if you need you can set a cron to backup your database hourly
or daily to the other server using mysql dump and scp.
I d
Hello,
As per your suggestions I tried to get some correct solution for the
problem, but there is a big problem for replication and it is network
connection. Though Internet is available to the Mfg. Site, it is not having
good speed and continuous. So that replication may not be a good choice. As
Hi,
Set up two-way replication between Corporate and Manufacturing. As long
as a live network connection is available between the two sites,
replication will carry on. Make sure that all your hardware is able to
handle the peak I/O loads, in order to keep replication humming along
seamlessly.
If
Replication works with Windows (we do it extensively here at work). And
it's definitely one option. But if there are any problems, then without
some monitoring mechanism, you'll not be alerted if replication chokes
(all that will happen is that updates to the slave will seemingly just
stop). You
Hi Ace,
If you cant affort downtime and if you are using innodb try removing auto
extend on the current data file and create a datafile in a different
partition and put autoextend on the same. If you are using MyISAM , you can
move few tables to different disk use symlinks.
--
Thanks
Alex
http:
Will try with dump and moving logs.
Can I just move my datadir=/usr/local/mysql/data to some other location and
change it in my.cnf? Will there be any complications to this?
Thanks,
Rajan
On 7/8/07, Ananda Kumar <[EMAIL PROTECTED]> wrote:
Hi Ace,
Can't you zip or move old bin-logs to a differe
Hi Ace,
Can't you zip or move old bin-logs to a different disk and release some free
space on the current drive.
regards
anandkl
On 7/9/07, Ace <[EMAIL PROTECTED]> wrote:
Hi,
We have crisis. Disk with MySQL database is full. Now we want to move
database to another disk. How can we do it?
backup and restore would be what i would do.
using either mysql administrator or mysqldump.
On 09/07/2007, at 3:45 PM, Ace wrote:
Hi,
We have crisis. Disk with MySQL database is full. Now we want to
move
database to another disk. How can we do it?
--
Thanks,
Rajan
Regards,
Hartlei
Sujay ,
> Tables : 1 (only 1) ::: Innodb or Myisam ?
I see lots of updates happening on that table so , how frequent do you
defragment the table .
--
Thanks
Praj
On Mon, 9 Jan 2006 01:46:39 -0800
Sujay Koduri <[EMAIL PROTECTED]> wrote:
>
> I am giving the system configuration which we are u
Hi Sujay,
Can you please post details like the my.cnf configs, how is the
load on system like cpu, memory, disk usage etc.
Thanx in advance
--Alex
On Mon, 09 Jan 2006 15:16:39 +0530, Sujay Koduri <[EMAIL PROTECTED]> wrote:
I am giving the system configuration which we are using to
I am giving the system configuration which we are using to run MySQL.
2-CPU 4G RAM, SAN filesystem.
MySQL version : 4.14 (INNODB)
OS : RHEL - 3
Amount of Data : 200G
No of Rows : 278 million approximately (Every day 2.5-3 million rows gets
added)
Transaction rate : 300-400 reads/sec, 110-120 upda
Hi Vishwas
These and many other answers can be found here :
http://dev.mysql.com/doc/refman/5.0/en/what-is.html
There is no practical limitation on the row size apart from the number
of fields x the size of these fields. eg. 1000 fields of varchar(255) or
larger will take up that space. I don't k
Hello,
Two admin tools to check out if you haven't already...
PHP, you can try PHPMyAdmin - http://www.phpmyadmin.net/home_page/index.php
Non-PHP, try MySQL's GPL MySQL Administrator -
http://dev.mysql.com/downloads/administrator/index.html
However, they too may not be suitable for remote admin
Relational Database Design Clearly Explained, Second Edition
ISBN: 1558608206
The original edition was my first primer on relational databases. It was
an excellent read.
Ben
Maurice van Peursem wrote:
Hi,
I'm relatively new to the database-scene. I've installed MySQL on Mac
OSX 10.3, which
A couple of good links for databases.
Database Design (quick and dirty, but gets the points across):
http://www.geekgirls.com/menu_databases.htm - the from scratch side
SQL:
Basics: http://www.sqlcourse.com (you probably already know this stuff -
but just in case.
semi-Advanced: http://s
- Original Message -
From: "Maurice van Peursem" <[EMAIL PROTECTED]>
To:
Sent: Sunday, November 27, 2005 6:33 PM
Subject: MySQL database design documentation
Hi,
I'm relatively new to the database-scene. I've installed MySQL on Mac OSX
10.3, which was easy. I've installed Perl sup
> -Original Message-
> From: Martijn Tonies [mailto:[EMAIL PROTECTED]
> Sent: 12 August 2005 10:43
> To: mysql@lists.mysql.com
> Subject: "mysql" database characterset
>
> Hi there,
>
> Is the "mysql" database always in UTF8 characterset for MySQL
> 4.1 and up?
>
> With regards,
>
> M
Hello.
> with php scripts. Now I am getting the message Unable to load database
> indicated by configuration file or something similiar when trying to connect
> to
> any database running on the server when the mysql user is running @localhost.
Please, send the exact error messages and wa
Are your php scripts by any chance called phpWebSite? If so, you might
find more help here:
http://www.phpwsforums.com/
What you're getting is almost definitely a PHP script catching some kind
of error trying to connect to the database server. You should have a
file called configure.php or so
The -e option with mysql allows you to run queries and would allow doing
user creation etc as well.
Aman Raheja
[EMAIL PROTECTED] wrote:
Hi,
I have to create user and database using script file.
My requirements are given below.
1. Login as root
2. Execute the script file for database and user
[EMAIL PROTECTED] wrote:
Hi,
I have to create user and database using script file.
My requirements are given below.
1. Login as root
2. Execute the script file for database and user creation.
3. Exit
My script file should have
mysql -u root
create database mnms;
user creation command
The sc
I hope you went at least to www.mysql.com ;)
-> Second tab "Developer Zone".
-> First tab "Downloads" from the second menubar.
-> Select version of your database
-> Select your OS
-> Pick a mirror
-> Have fun
Rik
Op donderdag 16 december 2004 14:28, schreef Serenity Schindler:
> Okay, extreme n
[snip]
Okay, extreme newbie. I probably just missed it but I went to the mysql
site to download the database so that I could use it at work and I am
having a problem finding it. The spot I expected it to be in there
wasn't a link for it.
Anybody got any ideas?
[/snip]
Try here http://dev.mysql.c
Schalk Neethling wrote:
Have you tried DBDesigner4 by fabForce?
I'm "working" with it at the moment. As far as I see, it doesn't
work on Mac and unfortunately DBDesigner manages to trash my
foreign keys definitions from time to time.
Regards,
A.
--
MySQL General Mailing List
For list archives: h
Have you tried DBDesigner4 by fabForce?
Andreas Ahlenstorf wrote:
Hi!
I'm looking for a good graphical database designer, supporting the
latest stable release of MySQL, MyISAM and InnoDB tables and foreign
keys. So far there are a lot of products. But I need one, which runs
on Windows and MacOS
David,
- Alkuperäinen viesti -
Lähettäjä: "David Griffiths" <[EMAIL PROTECTED]>
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>
Kopio: <[EMAIL PROTECTED]>
Lähetetty: Tuesday, October 19, 2004 9:33 PM
Aihe: Re: MySQL Database Corruption (InnoDB),
No worries about the late reply.
We took down the master, took a hot backup from the slave (I still need
to convert that 30-day license into a permanent one), moved it to the
master, started the master, and then took a hot backup and
re-initialized the slave. Took all of a few hours, and things
David,
I am sorry for a late reply.
The corruption clearly is in the ibdata file of the production database.
InnoDB Hot Backup checks the page checksums when it copies the ibdata files.
Since CHECK TABLE fails, the corruption probably is in that table. You can
try to repair the corruption by dum
Which version of PHP would be good for Red hat 7.3? can someone send URL from where I
can download the php pl?
Jochem van Dieten <[EMAIL PROTECTED]> wrote:Douglas Sims wrote:
>
> You should check out: http://onlamp.com/ L.A.M.P.
> (Linux/Apache/MySQL/Perl(or PHP)
Or Linux/Apache/Middleware/Pos
You can find a number of good starting point data
models here:
http://www.databaseanswers.com/data_models
You might also check out some of the applications on
sites like www.hotscripts.com and www.sourceforge.net
to see how they have structured their database for
similar projects. (or maybe you wi
Lynch 'im!!!
:-)
On Wed, 21 Jan 2004 13:33, Jochem van Dieten wrote;
> Douglas Sims wrote:
> >
> > You should check out: http://onlamp.com/ L.A.M.P.
> > (Linux/Apache/MySQL/Perl(or PHP)
>
> Or Linux/Apache/Middleware/PostgreSQL ;-)
>
> Jochem
>
> --
> I don't get it
Douglas Sims wrote:
You should check out: http://onlamp.com/ L.A.M.P.
(Linux/Apache/MySQL/Perl(or PHP)
Or Linux/Apache/Middleware/PostgreSQL ;-)
Jochem
--
I don't get it
immigrants don't work
and steal our jobs
- Loesje
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
I'm a java person and I'm happy to say you didn't rouse me. There are
many fine quality in lamp and java. I don't know PHP but I've seen some
really nice apps written in php. It looks like a nice clean language
and very nice for web development.
On Tuesday, January 20, 2004, at 03:34 PM, Doug
Hi
You should check out: http://onlamp.com/ L.A.M.P.
(Linux/Apache/MySQL/Perl(or PHP) are becoming the de facto standards for
web-based applications, I think far eclipsing Java (JSP/Servlets) and
Microsoft ASP/VB.
Unlike Java (which is driven to a large degree by Sun's promotion) and
ASP (he
On 10 Jan 2004, at 17:47, Michael Stassen wrote:
Eg. if you've two host entries; one '192.%' and the other '192.168.%'
- and you connect from 192.168.100.12, which row gets chosen?
As I understand it, 192.168.% is more specific than 192.%, so
192.168.100.12 would match 192.168.%
My thoughts ex
Steve Folly wrote:
On 9 Jan 2004, at 22:43, Michael Stassen wrote:
As [EMAIL PROTECTED] and [EMAIL PROTECTED] are separate entries in the user table,
each with its own password and privileges, they are 2 separate root
accounts from mysql's perspective. You could choose to think of them
as t
On 9 Jan 2004, at 22:43, Michael Stassen wrote:
As [EMAIL PROTECTED] and [EMAIL PROTECTED] are separate entries in the user table,
each with its own password and privileges, they are 2 separate root
accounts from mysql's perspective. You could choose to think of them
as the same accoun
riday, January 09, 2004 2:16 PM
To: 'Leo Donahue'; [EMAIL PROTECTED]
Subject: RE: mysql database, user table, two root accounts
That's not two root accounts. What that means is this:
The first line defines privileges for root connecting from localhost
The second line defines privile
Yes, this helps thank you.
-Original Message-
From: Arjun Subramanian [mailto:[EMAIL PROTECTED]
Sent: Friday, January 09, 2004 2:16 PM
To: 'Leo Donahue'; [EMAIL PROTECTED]
Subject: RE: mysql database, user table, two root accounts
That's not two root accounts. What tha
That's not two root accounts. What that means is this:
The first line defines privileges for root connecting from localhost
The second line defines privileges for root connecting from any remote
host. Hence the "%". It implies [EMAIL PROTECTED]
Hope this helps.
Arjun Subramanian
Georgia Tech Sta
At 14:35 -0700 7/8/03, Steve Quezadas wrote:
> have you done any "optimize" to your tables ?
it should help improving the query performance.
it's normal to have memory lower on each day, because your index
files are growing, and takes memory.
if you're not using innodb or bdb, you can try to
On Sat, Jun 28, 2003 at 11:35:54AM -0600, Jerry M. Howell II wrote:
> On Sat, Jun 28, 2003 at 06:14:07PM +1000, electroteque wrote:
> > lol of course
> >
> > mysqldump -u username -p databasename > databasename.sql
> >
>
> I am atempting to backup a database remotely. I added something like the
On Sat, Jun 28, 2003 at 06:14:07PM +1000, electroteque wrote:
> lol of course
>
> mysqldump -u username -p databasename > databasename.sql
>
I am atempting to backup a database remotely. I added something like the
following.
mysql> GRANT ALL PRIVILEGES ON db.*
-> TO david@'192.58.197.0/255.
At 1:08 -0400 6/28/03, Asif Iqbal wrote:
Can I dump a database while the database is running in mysql ?
Yes. You can, for example, use the mysqldump program. mysqldump
is a MySQL client program that, like all MySQL clients, requires
the server to be running.
--
Asif Iqbal
http://pgpkeys.mit.edu:1
lol of course
mysqldump -u username -p databasename > databasename.sql
-Original Message-
From: Asif Iqbal [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 28, 2003 3:08 PM
To: [EMAIL PROTECTED]
Subject: mysql database dump
Can I dump a database while the database is running in mysql ?
--
Do it like this:
mysql>GRANT ALL PRIVELEGES ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY
'mikaela02';
You forgot the hostname which is the @hostname is for
Respectfully yours,
Sherwin T. Ang
Systems Administrator
Tridel Technologies Incorporated
7F Hanston Building
Emerald Avenue, Ortigas Center
Your spelling of PRIVILEGES is also spelled wrong =)
specifying GRANT ALL PRIVILEGES on *.* to a user will make that user a
member of the superuser group such as mysql, just without the GRANT OPTIONS,
meaning that user's login wouldn't be able to GRANT other users.
if you want to specify the data
Hi,
>Is it possible to place MySQL data directories on a Linux ramdisk mount?
Oh yes. No fragmentation aftertaste.
Regards,
Gabriel
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
ibutes table 3
ID a4
wine3 x
2 nulls
===end chatter
-Original Message-
From: Michael T. Babcock [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 09, 2003 6:09 PM
To: Colaluca, Brian
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL Data
Hi Brian,
By no means am I a MySQL guru (or any other database server environment
guru, for that matter), but could you simply have a reference table that
indicates the percentage of the grape used in the relevant wine?
So, you might have three tables, Wines, GrapeVariety,
Wines_GrapeVarietiesUse
Colaluca, Brian wrote:
I have come to a brick wall on one facet of my design, however. I've come
to understand that having a lot of NULLs in your database may be a sign of a
poor design. And yet I'm having a problem reconciling this with the wildly
un-uniform world of wines from around the worl
Blend will be a cross reference with a one to many relationship
This is very simplified but an example of your data could be:
Select * from Wine;
++--+
| WineID | WineName |
++--+
| 1 | XYZ |
++--+
Select * from Grape;
+-+
I highly recommend you update the slave to the same version as the master.
Mark D. Wallace wrote:
> I'm trying to set up a replication database and cannot get the slave
> to parse the log files on the master.
> The slave is connecting to the master as indicated in the log file.
>
> I have trie
At 8/11/2002, you wrote:
>I believe that what you called "intermediate table" books are calling
>"table map", or something with the word "map" in it.
Hi Lloyd,
Books are nice to have (you can lie down to a sofa or sit in the loo with a
book), and what I started with (SAMS Teach Yourseft MySQL
on 8/11/02 2:47 PM, Pekka Saarinen, typed:
> At 8/11/2002, you wrote:
>> MySQL queries.. tables... design.
>>
>> http://garnet.acns.fsu.edu/~tlr7425/my_tables.gif
>>
>> There you will see a rough draft of what I am trying to do.
>>
>> Perhaps you will see some places that I will need to use a
At 8/11/2002, you wrote:
>MySQL queries.. tables... design.
>
>http://garnet.acns.fsu.edu/~tlr7425/my_tables.gif
>
>There you will see a rough draft of what I am trying to do.
>
>Perhaps you will see some places that I will need to use a table_map?
>
>Or you can advise me of how to arrange my keys
You need to add an additional table, favorites.
It should have three columns:
favoriteID INT,
userID INT,
favoriteTypeID INT REFERENCES FavoriteType.
Plus the additional column for the rating, assuming it's associated with a
favorite.
Each row represents a single preference (this way users ca
I am not very sure I understand the questionbut maybe column type 'enum'
is what you are looking for.
- Original Message -
From: "david" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 10, 2002 9:43 PM
Subject: MySQL database design, one column, 10 entries?
>
> I a
I need help with MySQL.
I just moved my servers and have new DNS names and IP addresses. I need to
update the databases to reflect the changes. I used PhpAdmin to make some
of the changes, but I am still getting "Internal Server Error"'s. Any help
in directing me for help would be appreciated.
Hi.
If you want someone to consider answering your problem, you should
write in a manner that it is understandable what you want.
I.e. give a detailed description of what your requirements are and
what you have already considered and why it won't work. Also have a
look at the mailing list archiv
Augey,
Wednesday, May 15, 2002, 4:25:15 PM, you wrote:
AM> Those files got so big that I had no more space on my hard drive and
AM> queriess would stop returning without any message telling me what was
AM> going on. All for the log files? Doesn't that seem like something that
AM> should be c
Those files got so big that I had no more space on my hard drive and
queriess would stop returning without any message telling me what was
going on. All for the log files? Doesn't that seem like something that
should be changed (atleast for the default install) ? It seems to me
that there s
they r the binary log files...
Ritu
On Tue, 14 May 2002, Augey Mikus wrote:
> what are the -bin.001 002 003 etc.. files in the /var
> directory? On my system they range in size from bytes to gigs. What
> are they and can they be cleaned?
>
>
> Augey
>
>
>
> ---
On Tue, 14 May 2002 18:49:48 -0400
Augey Mikus <[EMAIL PROTECTED]> wrote:
> what are the -bin.001 002 003 etc.. files in the /var
> directory? On my system they range in size from bytes to gigs. What
> are they and can they be cleaned?
it's mysql binary log file ... if you don't need the fil
* [EMAIL PROTECTED]
> 1. Is it a good idea to have all the columns in one big table ?
This will depend on the nature of your data. You say you have many varchar
columns. If many of them contains the same value, you could get substantial
speed/space improvements by splitting (normalizing) the tabl
On Saturday, April 06, 2002 at 5:32 PM,
Aravind NagaVenkata Gorthy asked:
> Could any one tell me what all the chages I have to make in order
> to make my existing (english version) of MySQL database compatable
> to the Japanese language.
It's a little hard to read your mind. Have you read sectio
On Sat, 6 Apr 2002 18:54:14 -0800 (PST)
Kip Kramer <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> After working happily for months, my MySQL (v. 3.23.48-1) database has begun
>displaying
> the following problem:
>
> Whenever I log in as mysql root and try to change privileges for my database as
>fo
Yes and no
If you are taking info from a live database you would have it in a steady
state to copy it. This means locking the tables.
But once you have a copy of the table all you would need to do is update the
changes from the logs.
Using replication for this I is the most simple way but wo
not quite sure what you mean by locking.
each table will be locked during "readout" for the dump automaticly for the
time the select runs and delivers data to the dumping program.
it is not needed to lock the tables (more than one) in advance for a dump, but
that, might better for dataintegrety.
Yes. Setup replication and peform the backup on the slave. Provided this is your only
purpose for having a slave, and there are no queries running on the slave, the specs
can be a lot lower than your master/production machine.
-Original Message-
From: Kathy Reyes [mailto:[EMAIL PROTECTE
How about trying to avoid using ODBC? Check out:
http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=22472&lngWId=1
or
http://www.icarz.com/mysql/
Craig
At 10:53 AM 3/12/2002 +0100, you wrote:
>Hi there,
>
>I have a problem with MySQL and the connection to it.
>
>What I want is
-Original Message-
From: Thi Cao [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 07, 2002 12:04 PM
To: Thi Cao
Cc: MySQL
Subject: RE: MySQL Database Replication
ds,
If I understand you correctly, that also means that the user repl can access
the mysql database where all the privilege info is
11:02 AM
To: Thi Cao
Cc: MySQL
Subject: RE: MySQL Database Replication
On Wed, 2002-03-06 at 14:26, Thi Cao wrote:
> When I grant privileges as follows, the slave gets updated:
>
> GRANT FILE ON *.* to repl@'%' identified by 'some_password';
>
> Could someone
On Wed, 2002-03-06 at 14:26, Thi Cao wrote:
> When I grant privileges as follows, the slave gets updated:
>
> GRANT FILE ON *.* to repl@'%' identified by 'some_password';
>
> Could someone please tell me why I must grant the FILE privilege on all
> databases for the repl (slave) to be able to up
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 07, 2002 10:42 AM
To: Thi Cao
Cc: MySQL
Subject: Re: MySql Database Replication Question
On Thu, Mar 07, 2002 at 08:37:00AM -0600, Thi Cao wrote:
> All,
>
> How can I notify an application running on the slave server that the
> slav
On Thu, Mar 07, 2002 at 08:37:00AM -0600, Thi Cao wrote:
> All,
>
> How can I notify an application running on the slave server that the
> slave database has just updated itself by means of replication. The
> reason I ask is that I know MySql currently doesn't support
> triggers, but my applicat
hanks everyone.
Thi
-Original Message-
From: James Housley [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 6:00 PM
To: Thi Cao
Cc: MySQL
Subject: Re: MySQL Database Replication
Thi Cao wrote:
>
> Hello everyone,
>
> This is my first attempt at MySQL database replica
Yes, I did flush the privileges when nothing else worked but that didn't do
the trick either. Thanks for trying.
-Original Message-
From: James Housley [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 6:00 PM
To: Thi Cao
Cc: MySQL
Subject: Re: MySQL Database Replication
Thi Cao wrote:
>
> Hello everyone,
>
> This is my first attempt at MySQL database replication. Can't seem to get
> it to work yet. The problem reported in the error log of the slave server
> is as follows:
>
> Error reading packet from server: Access denied for user 'repl@slave_host'
> (Usin
12.02.02 05:56:48, "D Bamud" <[EMAIL PROTECTED]> wrote:
>I need to create a database in MySQL that I need to bundle with my program
>for distribution. The user will have its own copy of MySQL running. User
[...]
>file system database bundle will be done before running the program. How to
>create
> Hello,
> I am interested in knowing :-
> 1) The maximum number of tables possible in MYSQL Database
> 2) The maximum number of columns that are in a table.
http://www.bitbybit.dk/mysqlfaq/faq.html#ch9_0_0
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http
You will not get 3.22 to recognize MyISAM format tables.
You need to either:
1. Upgrade your server to 3.23
or
2. Find a running 3.23 server, copy your table files to that server, ALTER
TABLE xxx TYPE=ISAM; on all your tables to convert back to older ISAM
format, and copy your table files back
> "Chase" == Chase Peeler <[EMAIL PROTECTED]> writes:
> There is alot of important info in those tables, and I really need
> them.
Sorry to broadcast this to the whole list, but Chase's supplied email
appears to be invalid, or at least bouncing at the moment:
Chase, I'm in the NCBI part of
It appears that your change to debian was also a change from the current
3.23 mysql version to the old 3.22 version ( major releases ). The old
version, 3.22, does not support MyISAM tables, so you'll need to upgrade to
the new version. Debian stable, aka potato, uses 3.22, but both woody + sid
(
Hi!
At 02:59 PM 8/7/01 +0300, you wrote:
>Grigory Bakunov writes:
>> Date |Fri, 3 Aug 2001 17:21 +0200
>> >From |TIGNAC BRUNO <[EMAIL PROTECTED]>
>>
>> Hello!
>>
>> TB> --- Reçu de CMB.TIGNABR 0298426574 03-08-01
17.21
>>
>> TB> Hello,
>>
>> TB> I plan to use MySQL/I
Date |Fri, 3 Aug 2001 17:21 +0200
>From |TIGNAC BRUNO <[EMAIL PROTECTED]>
Hello!
TB> --- Reçu de CMB.TIGNABR 0298426574 03-08-01 17.21
TB> Hello,
TB> I plan to use MySQL/InnoDB to store about 13 GB of data, into 40 tables. One
TB> of the tables is over 5 GB, and a sec
I hate to ask this on the list, but I have tried everything to unsubscribe
and nothing works. Any suggestions?
Thanks.
-Original Message-
From: TIGNAC BRUNO <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Friday, August 03, 2001 11:00 AM
Subject: [MySQL] Database siz
[EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> database,sql,query,table
>
> If you just reply to this message, and includ
- Is it possible to use mySQL for this purpose?
Yes
- Is it possible to set the database to be read-only?
If you use the compress command for your data in the database in not only
makes the files smaller is also makes them read only..
- We need to transfer the database structure/data to the new da
On Sat, May 19, 2001 at 01:18:42PM -0500, David Gullett wrote:
>
> I have 10 or so MySQL servers in the field, all writing data to a
> database of the same name. I would like to set up replication from
> all masters back to a single slave server and have each master write
> to a different databa
Usually it is not in the folders that are listed below. It is in one of
the server's folder that you don't usually have access to view.
Since you have only ftp you need to install phpMyAdmin from phpMyAdmin.net
on your server, htdocs.
Export your database using mysqldump dbname > somename.sql
Check with your ISP.
You need shell access.
ashok wrote:
>
> hi,
>
> sir,we have to upload mysql database on our website,the isp people has enable mysql
>for our websites,now we wanted to upload or export the mysql table,
> please give us the suggetion where to upload the tables and how odbc h
On Thu, Mar 15, 2001 at 05:07:08PM -0700, Steve Ruby wrote:
> Patrick Calkins wrote:
> >
> > Hello all;
> > Are there any known problems with storing the database files on a NAS
> > (network attached storage) device??
> >
> > also, can you run multiple MySQL daemons pointing to one common databa
Patrick Calkins wrote:
>
> Hello all;
> Are there any known problems with storing the database files on a NAS
> (network attached storage) device??
>
> also, can you run multiple MySQL daemons pointing to one common database, so
> you could have a "cluster" of database servers and one database??
97 matches
Mail list logo
