TTBMK, there is no such thing as 'auto flush' in MySQL.
When you say Everytime I add some record on my local computer then upload
... are you saying you upload the raw database files (from your data
directory), or are you inserting/updating the data in your Linux databases
with a query?
If you
Buyer beware ...
I was a bit surprised when I learned there was a version 3.0 of MySQL-Front
... the developer of MySQL-Front shut down the project after version 2.5. As
it turns out, this new version is unrelated to the original project created
by Ansgar Becker.
Though it has many of the same
Jamie:
I don't think your problem has anything to do with version 5.0 ... though
there have been some enhancements in security and user privs, the
fundamentals (IMHO) have not changed.
The problem is most likely with the application itself ... it needs to pass
the user ID and password, and the
Try c:\mysql\bin\mysql.exe
If that works, then put c:\mysql\bin the system's path.
- Original Message -
From: Betta Jazzy Brown [EMAIL PROTECTED]
To: Paul DuBois [EMAIL PROTECTED]; Betta Jazzy Brown
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Saturday, December 13, 2003 8:48 AM
Subject:
Why don't you check the Help utility for your particular operatiing system?
This is not a MySQL issue, and there are several ways you can accomplish it
depending on which version of the Microsoft Windows O/S you have.
- Original Message -
From: Betta Jazzy Brown [EMAIL PROTECTED]
To:
Swedish should not be a problem ... the chief software architect behind
MySQL is a Swedish-speaking Finn.
If you want the password to be bubba, then the syntax is:
/usr/local/mysql/bin/mysqladmin -u root password bubba
If the computer (host) name is snickers, it would be written as:
PROTECTED]
Sent: Friday, November 28, 2003 8:05 PM
To: Gerald R. Jensen; Stefan Hinz
Cc: [EMAIL PROTECTED]; robert_rowe
Subject:Re: MySQL Win32 Service
If I understand correctly, the MySQL source is available. If you are
familiar
with the code that registers/starts/stops services
How closely does the MySQL Service on Win32 platforms conform to any known
standard for installing/removing services?
I raise the question because the vendor that provides the utility we use to
create our installation package claims that MySQL uses non-standard commands
for installing and
the service.
I think the vendor in question has buggy/incomplete code, and is blaming
MySQL for their problems.
G R Jensen
- Original Message -
From: Stefan Hinz [EMAIL PROTECTED]
To: Gerald R. Jensen [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; robert_rowe [EMAIL PROTECTED]
Sent: Friday
Are you running Replication?
- Original Message -
From: jon yeargers [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, October 14, 2003 10:12 AM
Subject: .bin.### files in /var/lib/mysql
The /var/lib/mysql directory is collecting server name-bin.### files.
What are these? Should I
Might also help if he would specify the O/S ...
- Original Message -
From: Martin Gainty [EMAIL PROTECTED]
To: Bob Demers [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, September 01, 2003 1:12 PM
Subject: Re: Can't start MySQL
Bob-
I would start to look in
\Apache
Why not post it here, or give us a link to download it from your server?
- Original Message -
From: Francesc Guasch [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 4:47 AM
Subject: Contributing to MySQL
I have a script that dumps the grants of a MySQL
Database and
You didn't say which version of MySQL you are using, or if you are using
InnoDB tables. I'll assume you are using MyISAM tables, and are **adding** a
drive to the system.
1. Install / mount the new drive so it is available to the O/S and assign it
a drive letter.
2. Stop the MySQL Server (in
Benny:
What do you mean by 'recursive sql statements'?
If you are talking about triggers and stored procedures, the answer is no.
Gerald Jensen
- Original Message -
From: Bernhard Schmidt [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 2:58 AM
Subject: recursive
I just ran your query (create and both inserts), and it worked like a charm
on a Win32 MySQL 3.23.52.
Just out of curiousity, why are putting the \r in?
- Original Message -
From: Tab Alleman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 20, 2003 10:51 AM
Subject: Import
Try ...
/usr/local/bin/mysqldump -uUserName --opt $db $location$db.sql
- Original Message -
From: Scott Haneda [EMAIL PROTECTED]
To: Cal Evans [EMAIL PROTECTED]; MySql [EMAIL PROTECTED]
Sent: Saturday, March 01, 2003 5:18 PM
Subject: Re: Best way to dump for daily archiving
on
Did you start the server? Normally, error 1064 means the server has not been
started.
- Original Message -
From: jsp [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, February 07, 2003 6:49 PM
Subject: NEWBIE to mysql
Can anyone tell me why I keep getting an ERROR 1064 with this
Clyde:
I don't know what percentage of MySQL users are running on Windows servers,
but I suspect it is higher than you might think. IMHO, you would also find a
number of situations where MySQL is being used on Win32 platforms for
development, while production databases are being served up on
Did you configure your web server (Apache?) for MySQL and PHP?
- Original Message -
From: Mohammed Fouwaaz [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, December 25, 2002 11:59 AM
Subject: Unable to establish database connection via PHP3
Hello mysql gurus
I am fairly new to
Don't know anything about PWS ...
- Original Message -
From: Mohammed Fouwaaz [EMAIL PROTECTED]
To: Gerald R. Jensen [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, December 25, 2002 12:36 PM
Subject: Re: Unable to establish database connection via PHP3
It is Personal Web
MySQL is not the problem.
Are you shutting down MySQL before you shutdown/restart the machine?
When you say Win9x, which flavor or Win9x do you really mean ('95, 98,
98SE?)
- Original Message -
From: Lalit Chandwani [EMAIL PROTECTED]
To: MySql Mail [EMAIL PROTECTED]
Sent: Saturday,
Technically, the files can work. But the best way (IMHO) is to use mysqldump
out of the Win32 box, copy that file to the Linux box and pipe it in. Make
sure you use options in mysqldump to do complete table creation, etc.
Gerald Jensen
- Original Message -
From: tmb [EMAIL PROTECTED]
To:
Try:
mysql -u{username} -p {databasename}filename.sql
Make sure you put full create statements in the file, along with nay data
you wish to insert into the database.
Gerald Jensen
- Original Message -
From: TopMailBox [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent:
Open the mysql monitor, and ...
DROP DATABASE databasename;
- Original Message -
From: Will Standley [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, December 06, 2002 5:56 PM
Subject: How to delete MySQL db ?
I have a couple of test MySQL data bases on my Linux/Apache box and
Neal:
What you are really asking is: Does MySQL support stored procedures?
The answer is ... at this point ... no. Implementation of stored procedures
is on the 'to-do' list, but it will be awhile before you see it.
There are some work-arounds ... do a search of the archive for this list, or
You don't have to develop or buy anything. You can use mysqldump in
conjunction with a shell script to do what you want, and automate it with
either the Windows Scheduler (on Win32) or a cronjob (Linux, *nix).
- Original Message -
From: Neil Tompkins [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
my ISP would this be a problem ? Maybe you
provide me with a simple example ? Since I'm very new to mySQL and have no
knowledge of unix.
Thanks
Neil
From: Gerald R. Jensen [EMAIL PROTECTED]
Reply-To: Gerald R. Jensen [EMAIL PROTECTED]
To: Neil Tompkins [EMAIL PROTECTED], [EMAIL PROTECTED
What would cause the MySQL server to just shutdown, apparently on its own?
This server is running on a Linux (RH 7.3) (Dell) box with 512mb RAM and a
SCSI RAID array. The MySQL version is 3.23.53, installed from RPM's. The
RPM's were downloaded from a MySQL mirror (did not install the versions on
Just a guess, but I would say the problem rests in the network or network
configuration. We have a number of installation running replication (both
Win32 and Linux), and have never seen anything like this.
Gerald Jensen
- Original Message -
From: Vaso Koutsonikola [EMAIL PROTECTED]
To:
MySQL is good on the Win32 platform ... slower than on Linux / Unix / BSD
etc., but nonetheless it is a good performer.
We have several of our Win32 clients who have switched to Linux servers or
have augmented their Win32 servers with Linux servers to specifically handle
database duties... the
Yes, you can replicate from Linux to Win2K ... but both servers have to be
properly configured.
Did you edit my.cnf on your Linux machine so it knows it is the Master
(Win2K would be the Slave)?
- Original Message -
From: Rick Root [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday,
Connection type, network configuration, operating system, ODBC
configuration, etc. can be factors. You haven't shared any of that
information, so it is hard to speculate.
- Original Message -
From: Yanglong Zhu [EMAIL PROTECTED]
To: Gerald R. Jensen [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED
John:
How are you connecting the nodes running Mascon, etc. to the server ...
MyODBC, libmysql, etc.?
If the problem started when you changed the server name, then check the DNS
settings on the client machines. It would seem they are trying to connect to
a non-existant DNS name.
Gerald Jensen
Network problems ... something is breaking TCP/IP.
- Original Message -
From: Yanglong Zhu [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, October 12, 2002 4:57 AM
Subject: Lost connection to MySQL server during query
Hi there,
This is an error message from MySQL when I try
MySQL does not support stored procedures.
- Original Message -
From: Ian Hagan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, October 13, 2002 7:10 PM
Subject: Stored Procedures
Hello All List Members,
My name is Ian Hagan. I am a database developer specialising in Delphi. I am
Or your could ...
mysqldump -uusername -p -hhostname --all --add-drop-table --add-locks --
complete-insert --compress --extended-insert --flush-logs --force --opt --ve
rbose --databases databasename tablename test.sql
- Original Message -
From: swati sandhya [EMAIL PROTECTED]
To: John
How stable is MySQL? Here's a quick case study ...
Our clients are organizations involved in Electronic Journalism ... Radio
and TV news. We produce a suite of applications that permit them to do word
processing, document organization, data management (from news wire
services), archives,
of batch files to start/stop the service.
Gerald Jensen
-Original Message-
From: Uriel Wittenberg [SMTP:[EMAIL PROTECTED]]
Sent: Friday, September 13, 2002 3:24 AM
To: Ed Carp; Gerald R. Jensen; [EMAIL PROTECTED]; Paul DuBois;
[EMAIL PROTECTED]
Subject:Re: Starting/stopping
If you set it to 'Manual', then you should be able to start/stop the service
with the appropriate NET START/STOP MYSQL command.
- Original Message -
From: Uriel Wittenberg [EMAIL PROTECTED]
To: Gerald R. Jensen [EMAIL PROTECTED]; [EMAIL PROTECTED];
Ed Carp [EMAIL PROTECTED]; Paul DuBois
Clarify your question ... are you trying to drop TABLES, DATABASES, or
modify user privileges?
If you are trying to modify user privileges, use GRANT or REVOKE.
- Original Message -
From: Daniel Curry [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 10, 2002 6:26 PM
Which version of WinXP (Pro or Home)?
On WinXP Pro, you'd have to install MySQL as a service, in which case it can
either started manually or automatically. WinXP Home is more like WinME
(yuck!) or Win98, where you can start MySLQ from a batch file.
- Original Message -
From: Uriel
You are right, Paul ... the service is optional on WinXP Pro. I'm a creature of habit!
-Original Message-
From: Paul DuBois [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, September 10, 2002 7:32 PM
To: Gerald R. Jensen; Uriel Wittenberg; [EMAIL PROTECTED]
Subject:Re: Default Win
Odds are you have not granted your 'root' user rights to login from a node
on the network. Instea dof using root, I would suggest you create another
user with rights to login across the network.
- Original Message -
From: John Hanley [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday,
Pierrot:
Do a search on the archive (http://lists.mysql.com/) for this list ... look
for images and blobs ... you should find numerous topics with the info you
are looking for.
Gerald Jensen
- Original Message -
From: navarra/mail.satori.fr [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
Sounds like TCP/IP is not running on your machine.
- Original Message -
From: guilherme.afm [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, September 02, 2002 10:45 AM
Subject: ERROR 2004
I downloaded mysql, i am not sure about the version,
number but i think is the last stable
Trevor ...
Do you want to drop the tables, or simply delete the data in them and retain
the table structure?
To delete data ...
USE databasename;
DELETE * FROM tablename;
To drop tables ...
DROP TABLE [IF EXISTS] tablename1 [, tablename2,...] [RESTRICT |
CASCADE]
If you drop a
I use a shell script and set up a cron job. Here's the shell script (I call
it mydbbak.sh)
#
#!/bin/sh
#
# Create /dbbakup directory
# $1 = Unix/MySQL Username
# $2 = Unix/MySQL Password
if [ ! -e /dbbakup ]
then
mkdir /dbbakup
Jerry:
This is really off-topic for this forum, but why not set a cookie with a
short life (expiration). Each page can check for the valid cookie. Then in
your logout page, delete the cookie.
Gerald Jensen
- Original Message -
From: JeRRy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
Our application (Win32) gives MySQL a real pounding, but we have never had
it die on a server with proper resources.
On Win32 systems, you can not underestimate the importance of virtual memory
(swap file) and drive defragmentation. On Win32 systems with SCSI RAID, we
set the virtual memory to
First, make sure you purchase the necessary licenses and support contract.
Building your own installer is a piece of cake. We use InstallConstruct, but
InstallShield, Wise, etc. will do just fine. Create the database(s) the way
you want them, and include them in your installer package. Make sure
What O/S are you using ... Win2k, WinXP, etc.?
- Original Message -
From: Shion D. Deysarkar [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, July 31, 2002 11:15 PM
Subject: dos trouble
I'm trying to start up mysql through dos prompt. When I enter a
MySQL does not support sub-queries. Take a look at JOINS
(http://www.mysql.com/doc/J/O/JOIN.html)
- Original Message -
From: Luis Rodrigues [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 31, 2002 6:03 AM
Subject: Problem with subqueries
hi,
I have some sql code that I
No can do. Replication is one-way.
You can, however, have multiple Slaves.
- Original Message -
From: Bhavin Vyas [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 31, 2002 12:35 AM
Subject: Replication Circle
Hello,
Is there a way to have DB-A and DB-B such that DB-A is
Ray:
The only database you shouldn't mess with is the mysql database ... it is
the equivalent of the 'master' database found in other systems, and contains
all of the rights and privileges you invoke.
Get to know the 'GRANT' command in the MySQL Manual
(http://www.mysql.com/manual.php) ...
Did you first create a database named 'poll'?
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, July 19, 2002 4:33 AM
Subject: Create DataBase tabe for a user
Hello,
When I run grant all on poll.* to edward@localhost identified by
'edward'; command...
I
Don't use 'root' ... create a new user, and make sure you GRANT the proper
privs (i.e.:
USE mysql;
GRANT ALL PRIVILEGES ON *.* TO username@localhost IDENTIFIED BY
'password';
GRANT ALL PRIVILEGES ON *.* TO username@% IDENTIFIED BY 'password'
WITH GRANT OPTION;
- Original Message
MySQL doesn't have an internal clock. It uses the O/S's clock.
Each of our servers (both Linux and Win32) running MySQL logs into a time
server to set the system clock twice a day. Time references in the MySQL
databases are always dead-on.
- Original Message -
From: Paul Wallace [EMAIL
Kristian:
Possible? I suppose, but not very practical. It would be
ssllooww, you'd need to supply an application to permit
access to the data, and how would you handle licensing?
Gerald Jensen
- Original Message -
From: Kristian Koehntopp [EMAIL PROTECTED]
To: MySQL
Rene:
I think a good deal depends on the size of the image files themselves. There
are a number of apps that store small files (i.e.: icons, small gif's,
etc.), which seems to make sense.
Larger files may be problematic. There was quite a discussion on this issue
here just last week ... do a
PROTECTED]]
Sent: Friday, July 05, 2002 11:39 AM
To: Gerald R. Jensen
Cc: Ben Bennett; [EMAIL PROTECTED]
Subject:Re: Dreamweaver MySql Databases
Does your server support .jsp pages?
Does your version of dreamweaver support editing .jsp pages?
If yes to both questions, you can install
Tim:
From the DB side, it is pretty easy to do ... a table with 3 columns will
suffice:
CREATE TABLE queries (
q_id int(11) NOT NULL auto_increment,
q_name varchar(30) default NULL,
q_text text,
PRIMARY KEY (q_id)
);
Your app needs to be able to
Marvin ...
It is a lot easier than you may be thinking.
Just make sure you download the Win32 binaries, and run the setup wizard. In
most cases, the installer's defaults are fine, but you can put the server on
any drive/partition you like. Check out the MySQL Manual's Win32
installation
Julian:
In my experience, MySQL doesn't project release dates. The surest way to
avoid pulling a Microsoft (miss release dates) is not to project release
dates in the first place.
As I understand it, they are working through the to-do list
(http://www.mysql.com/doc/T/O/TODO_MySQL_4.0.html) in
Mark:
Do you have my.ini (or my.cfg) set to ignore case in table names?
set-variable = lower_case_table_names=1
Gerald Jensen
- Original Message -
From: Mark Weiler [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 24, 2002 5:56 PM
Subject: Case Sensitivity for CHECK TABLE
Taylor ...
Check out ...
http://hotwired.lycos.com/webmonkey/databases/tutorials/tutorial4.html
... or ...
http://vtwebwizard.com/tutorials/mysql/
- Original Message -
From: Taylor Lewick [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 24, 2002 1:16 PM
Subject: mysql php
Emma:
It really depends on the language you wish to use ... could be Perl, ASP,
PHP, etc.
If you choose PHP, check out http://www.phpbeginner.com. You can obtain PHP
(and find other useful links) from http://www.php.net
Gerald Jensen
- Original Message -
From: Emma Grant [EMAIL
Monty:
Excellent idea.
Gerald Jensen
- Original Message -
From: Michael Widenius [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Cc: Gerald Clark [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Thursday, June 13, 2002 7:09 AM
Subject: Spams on MySQL mailing lists
Hi!
I
Stephen:
The *best* help for the kind of questions you have is in the MySQL Manual.
Gerald Jensen
- Original Message -
From: Stephen Brown [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 12, 2002 8:22 PM
Subject: Installation Help
I am installing MYsql under linux and
Somebody will ... make it clear in whatever licensing statement you have
that the end-user is responsible for licensing third-party components.
- Original Message -
From: Michael Ivanyo [EMAIL PROTECTED]
To: mysqllist [EMAIL PROTECTED]
Sent: Tuesday, June 11, 2002 10:24 PM
Subject:
We use the current stable version of MySQL on a server running Apache 2.0
with no problem.
- Original Message -
From: Jeff Whitman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, June 09, 2002 10:55 AM
Subject: Apache 2.0
Dear Sir or Ms.
Is there a stable version of MySQL that
Well, for starters, if you are trying to put data into the database, your
query should use INSERT ... not SELECT.
Here's a snippet from one of my scripts ...
$query_insert=INSERT INTO tablename (column1, column2, textdata) VALUE
('$column1','$column2','$textdata');
if (!($result_insert =
Not to add insult to injury, but keeping backups on the same machine and
media your databases are installed on is asking for trouble. And power
outages are predictable, so UPS protection is critical. Enough said.
I would speculate that one or more of the files in the /data/mysql/ folder
were
Bookmarking?!
No, MySQL does not support bookmarking ... it is relational database
manager, not a word processor. All you have to do is save the query you run,
and it will return the same results.
- Original Message -
From: SB Lim [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday,
What platform (Win32, Linux, BSD, etc.) are you using?
If you have Win32 machine in the mix (doesn't need to be a server), suggest
you use the Export tool in MySQL-Front (http://www.anse.de/mysqlfront/).
We've replicated databases from Win32 to Linux and Linux to Linux with it
many times.
Stuart:
Something is wrong with your query. A little more detail?
G Jensen
- Original Message -
From: Stuart Elston [EMAIL PROTECTED]
To: mysql [EMAIL PROTECTED]
Sent: Wednesday, May 01, 2002 5:35 AM
Subject: basic warning
on a valid dB, I get the following warnings.
Warning:
If a trailing slash were required, mine would not work:
[mysqld]
basedir=d:/mysql
datadir=d:/mysql/data
language=d:/mysql/share/english
skip-locking
set-variable = key_buffer=16M
set-variable = max_allowed_packet=1M
set-variable = thread_stack=128K
What Operating System (WinNT / 2K / 98 / etc.) are you using?
- Original Message -
From: Timothy Keefe [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, April 28, 2002 10:18 AM
Subject: mysql server question
Hi, all,
Two questions . . .
1. Windows is giving me the 1067 error,
What Operating System (WinNT / 2K / 98 / etc.) are you using?
- Original Message -
From: Timothy Keefe [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, April 28, 2002 10:18 AM
Subject: mysql server question
Hi, all,
Two questions . . .
1. Windows is giving me the 1067 error,
To: Gerald R. Jensen
Cc: [EMAIL PROTECTED]
Subject:Re: Multi Line SQL Statements
It's The MySQL Control Center program.
I can take and save the sql statements from Mycc to a text file and
call MySql c:\sql.txt and it runs fine...
wierd
Gerald R. Jensen wrote:
Michael ...
Works
Michael ...
Works for me ... at the console:
mysql create table zipsta2 (zip char(5), state char(2));
Query OK, 0 rows affected (0.06 sec)
mysql create table zipstates (state char(2), zip char (5));
Query OK, 0 rows affected (0.06 sec)
Put the same query in a script piped into MySQL with same
Joe:
Here is what we do ...
- Login as Administrator
- Open DOS Prompt, switch to the drive with MySQL on it, and CD\MYSQL\BIN
- Type MYSQLD-NT --INSTALL
- Type NET START MYSQL
If that doesn't do the trick, your C:\WINNT\MY.INI (or C:\MY.CNF) may not be
correct. Most coomon mistake is to use
Can the TZ be set in my.cnf (my.ini) when the MySQL server starts up?
I have read the manual on this, and tried various combinations, but haven't
hit the right syntax.
Gerald Jensen
- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday,
Per client? Per database? The only timezone setting in the MySQL manual is
for the server (tz), and permits you to set it to your local timezone so it
does not return values in GMT.
If you want clients to have different timezones, perhaps you should write
that capabilty into your front-end
Depends on the language you are writing in, and the level of your
programming skills.
If your users/guests have database entries, it would be a rather trivial
task to set their timezone in a column in the database, then write your app
to calculate their local time based on the offset from GMT.
If you are running RH7.2, start your GUI and go to System / Service Manager.
Locate mysqld, and make sure it is checked to automatically start on bootup,
then save your settings, and click the start button.
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday,
Check the location of the configuration file (should be either c:\my.cnf ~
OR ~ c:\winnt\my.ini), then edit the contents of that file. Here is a
sample:
[client]
#password=my_password
port=3306
#socket=MYSQL
#
[mysqld]
port=3306
#socket=MYSQL
skip-locking
#enable-locking
set-variable =
- Click 'OK' then click 'Start'
Gerald Jensen
- Original Message -
From: Alexander Hampel [EMAIL PROTECTED]
To: Gerald R. Jensen [EMAIL PROTECTED]
Sent: Monday, March 18, 2002 7:45 AM
Subject: AW: NT service problem
Thanks - my.ini is used.
Tried to use come of your parameters
This has been covered here a number of times before ... a search of the
archive avoids the need to repeat the same info.
That being said ...
We use a cronjob (root) that calls a shell script at 3am daily.
The line in the cronjob is:
* 3 * * * /usr/local/bin/dbbakup.sh username password
The
Try ...
CREATE DATABASE /*!32312 IF NOT EXISTS*/ databasename;
... then try reading the manual!
- Original Message -
From: Radhakrishna Mohan Tadepalli [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 13, 2002 11:40 AM
Subject: Create database if does not exist.
I want
This 'developer' is feeding you some BS.
MySQL handles XML data as well as any other type of data. The functioanlity
of a particular database has a lot to do with the programmer who designs the
schema. Maybe this 'developer' doesn't know how to design an XML/MySQL
application ... but that
We us a shell script that calls a cronjob (root) at 3am daily.
The line in the cronjob is:
+ACo- 3 +ACo- +ACo- +ACo- /usr/local/bin/dbbakup.sh username password
The shell script:
This off topic, but one of our programmers is interested in NuSphere's PHPEd
development interface and I would liek some feed back from other users.
His interest lies not so much in using for database table modeling, but for
PHP and Perl development. I am well aware of the conflict a few months
Christo:
Write a query that does what you want to a text file called
virtusertable.sql:
USE databasename;
SELECT name FROM tablename;
Then run the query from the command line (mysql -uusername -p
databasenamevirtusertable.sqlvirtusertable.txt)
Gerald Jensen
- Original Message -
From:
Christo:
Write a query that does what you want to a text file called
virtusertable.sql:
USE databasename;
SELECT name FROM tablename;
Then run the query from the command line (mysql -uusername -p
databasenamevirtusertable.sqlvirtusertable.txt)
Gerald Jensen
- Original Message -
From:
Luie:
Here is a grant script we use ... check the syntax against the query you
were using:
USE mysql;
GRANT ALL PRIVILEGES ON *.* TO username@localhost IDENTIFIED BY 'userpwd';
GRANT ALL PRIVILEGES ON *.* TO username@% IDENTIFIED BY 'userpwd';
GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED]
Frans:
Legalities aside, why not let fairness and common decency prevail? The MySQL
team has a created a powerful, functional DB server. If you use their
product(s) in a commercial application for which you are being paid, why
would you NOT want to purchase a license?
If the US$200 price is too
Dear - -:
I would revoke all permissions for dummy, then create new permissions for
users on a database-by-database basis. If you look at the syntax for GRANT
in the manual, you can stipulate which databases a user would have access
to.
A word of caution: don't use root. Create a user for
Matthew:
There is no 'twist' here ... once your Apache server is configured to
support MySQL and PHP, just design the appropriate schema for each website
and create a database for each site requiring MySQL support.
I would suggest you pick up one (or more) of the books available on MySQL
and
You can't try http://www.appsolute.nl/heraut/ ... it is a restricted site.
Must be a commercial package or subscription service.
Gerald Jensen
- Original Message -
From: Norman Khine [EMAIL PROTECTED]
To: Stan Lester [EMAIL PROTECTED]
Cc: Mysql [EMAIL PROTECTED]
Sent: Sunday, January
Stan:
I don't know as I would call anything involving MSSQL Server 'painless, but
it can be done.
Do a search of the list archive (http://lists.mysql.com/), looking for
'SQL7' or 'MSSQL'. There have been dozens of posts over the last couple of
years describing different ways to approach the
1 - 100 of 163 matches
Mail list logo