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
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
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
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
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]; mysql@lists.mysql.com
Sent: Sunday, August 05, 2007 4:01 AM
Subject: Re: MySQL database synchronizing from 2
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).
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
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
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,
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?
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
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
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
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
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 using
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
- Original Message -
From: Maurice van Peursem [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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
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:
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,
-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,
Martijn Tonies
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
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
[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
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
[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
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 newbie. I
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
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:
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), according to Innodb Hot Backup
No worries about
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
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
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
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
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
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,
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:
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
immigrants
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
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
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
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
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 that means
, 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 privileges for root connecting from any
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
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 ?
--
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
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
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
following.
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
Do it like this:
mysqlGRANT 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
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)
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,
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 Database Design
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;
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
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 tried to
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
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, or
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 table_map?
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 in 21
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 am
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
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
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
On Tue, 14 May 2002 18:49:48 -0400
Augey Mikus [EMAIL PROTECTED] wrote:
what are the host-bin.001 002 003 etc.. files in the mysql_dir/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
they r the binary log files...
Ritu
On Tue, 14 May 2002, Augey Mikus wrote:
what are the host-bin.001 002 003 etc.. files in the mysql_dir/var
directory? On my system they range in size from bytes to gigs. What
are they and can they be cleaned?
Augey
* [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
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 section
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
follows:
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
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
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.
How about trying to avoid using ODBC? Check out:
http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=22472lngWId=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 to
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 application
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
slave database has just updated itself
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 update
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 please tell me why I must grant the FILE
-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
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
-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
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'
(Using
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 such
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
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 NLM, and
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
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
(
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 second
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/InnoDB to store about 13 GB
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 size
[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 include the
- 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
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 database.
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 has to
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
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??
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 database, so
you
97 matches
Mail list logo