Hello
I belive this is not the correct place to ask the
question. You can try your discussion forums at
http://www.webyog.com/forums for SQLyog specific
questions.
Karam
--- William IT [EMAIL PROTECTED] wrote:
Why SQLyog can not insert/update Table w/o Primary
Key? Is there additional setting
Out of interest is there any advantage of using a primary key?, or is it
perfectly ok/normal not to specify one?.
Im not quite sure what a primary does. I only used a primary key on one
table which had auto_increment column only because it forced me to add it.
??
Hello
I belive this is not
The character sets in both mysql severs in linux and windows are the same.
When I query a table which has the same data in spanish with accents I can see the
characters written are different.
My goal is to extract data from one of the data bases and be able to get then to the
other database
Carlos,
The character sets in both mysql severs in linux and windows are the same.
When I query a table which has the same data in spanish with accents I can see the
characters written are different.
1) So what are the values of the character_set and character_sets
variables, anyway?
2)
Probably this is what you want
http://www.webyog.com/forums/index.php?act=STf=5t=351s=7cd9c97584811d72b9305d3e691ab28f
Karam
--- Daniel Crompton [EMAIL PROTECTED]
wrote:
Out of interest is there any advantage of using a
primary key?, or is it
perfectly ok/normal not to specify one?.
Im not
Hi folks,
A couple of my sites are intermittently getting the following error:
2014 - Commands out of sync; You can't run this
command now
select configuration_key as cfgKey,
configuration_value as cfgValue from configuration
On one site the error is being reported regularly
hello all,
sorry for the newbe question, but want is the correct command line sytax to
restore table data from a file, table_name.sql
each of our .sql files contains all the table structure and insert data and we
need to restore a whole bunch of tables and data.
TIA
--
MikemickaloBlezien
Anthony Ward wrote:
SELECT userid FROM place WHERE acos( cos($longitude) * cos($latitude) *
cos(place.latitude) *cos(place.longitude) +cos($longitude) * sin($latitude)
* cos(place.latitude) * sin(place.longitude) +sin($longitude) *
sin($latitude) ) * 3963 = 1000);
Would you consider this HORRIBLY
The SOURCE command will allow you to execute files in batch mode:
Mysql SOURCE table_name.sql;
Check http://www.mysql.com/doc/en/Batch_mode.html
For more info.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Mike Blezien [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June
http://www.mysql.com/doc/en/Commands_out_of_sync.html
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Andrew Hazen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, 03 June, 2003 09:40
Subject: Meaning of error codes
Hi folks,
A couple of my
Thanks, that exactly what I was looking for. been battle all nite with a crashed
server and trying to get everything back up... appreciate the help. :)
Mike Hillyer wrote:
The SOURCE command will allow you to execute files in batch mode:
Mysql SOURCE table_name.sql;
Check
Greetings,
in my last email nobody tackled the schema copy issue.
Here is what I need to do:
I have a live database that contains several tables. I need
to create a history database with the same tables (without the data).
I would like to do this without manually creating all the tables in
the
Hi Darryl,
Why not use mysqldump --no-data [database] [table1] [table2] ...
John Griffin
-Original Message-
From: Darryl Hoar [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 03, 2003 10:49 AM
To: [EMAIL PROTECTED]
Subject: copying
Greetings,
in my last email nobody tackled the schema
use mysqldump to just dump the schema. Then edit the script to change the
database name and pump it back into mysql.
=C=
* Cal Evans
* http://www.christianperformer.com
* Stay plugged into your audience
* The measure of a programmer is not the number of lines of code he writes
but the number of
Stefan Schulte [EMAIL PROTECTED] wrote:
i am analyzing a very strange behaviour of mysql-3.23-53-log
on a Suse 8.1 system:
I have created a table Customer with a column:
customer_id int(11)
Now i want to select all rows with customer_id=41:
SELECT * from Customer WHERE
Hi, I've been struggling for a couple of days trying to get phpMyAdmin to
accept csv files for data uploads onto my hosted MySQL, and was having no
success using v2.5, despite 'local file being switched On at both ends.
My ISP just installed v2.5.1 and whooppe! it works.
I wouldn't
Hi there, I ´m using the Mysql control center with a database called dbONE
in a PC, and I would like to copy it to another PC, Do you have any idea to
how can I do it? I dont wanna create all the tables again...
Thanks a lot
mysql select * from Tickets limit 1;
I tried mysqldump in past but it do come INSERT statement (with DATA). Is
there any option if you just need schema. I might have missed it.
Appreciate it,
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 03, 2003 9:51 AM
To: [EMAIL PROTECTED]; [EMAIL
Please ignore my first mail. I got the answer in next email.
Regards,
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 03, 2003 9:51 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: copying
use mysqldump to just dump the schema. Then edit the
At 11:27 -0400 6/3/03, Asif Iqbal wrote:
mysql select * from Tickets limit 1;
I currently have two databases set up with a master/slave replication
environment. Right now, the tables are MyISAM, however I want to
migrate to InnoDB so I can gain transactioins. I've worked through the
processes and nearly everything seems straightforward, except: Does the
conversion
Try -E option or put \g in end of your sql statement like below
Mysql -u id -ppasswd -E -e show innodb status
OR
Mysql -u id -ppasswd -e show innodb status \g
I am not sure it is little g or capital G. Try both way.
-Original Message-
From: Asif Iqbal [mailto:[EMAIL PROTECTED]
Sent:
At 18:30 -0500 6/2/03, Michael Franch wrote:
To whom it may concern,
I am using MySql v.4.0.13 and am trying to query the user
table from Visual
Basic using ADO. If the user has an entry, that is uppercase lowercase,
e.g. Jim, and my query is:select user from mysql.user where user ='Jim'
the
mysql select * from Tickets limit 1 \g
At 11:39 -0400 6/3/03, Asif Iqbal wrote:
I want the columns unwrapped to make it easy to read. Sorry if I confused
you earlier
I still don't know what you mean. What would this output *look like*?
Please show an example.
On Tue, 3 Jun 2003, Paul DuBois wrote:
At 11:27 -0400 6/3/03, Asif Iqbal
I have a links page that has categories.
I am attempting to place category links on one side, and the actual links on
the other.
However when I do this, I get the following result:
category1
category1
category1
category2
Here is the code I am using:
?php
// Read...
$link_info = SELECT
something like this
++-+---++++---+---+-+
| id | EffectiveId | Queue | Type | IssueStatement | Resolution | Owner
| Subject | InitialPriority |
Asif,
try this:
prompt echo select * from Tickets limit 1; | mysql mydb result.file
You get everything in ONE line.
Cheers,
Thomas
On Tue, 3 Jun 2003, Asif Iqbal wrote:
mysql select * from Tickets limit 1;
use a smaller font. This is really a function of your shell or client, not
MySQL.
humbly,
=C=
* Cal Evans
* http://www.christianperformer.com
* Stay plugged into your audience
* The measure of a programmer is not the number of lines of code he writes
but the number of lines he does not have to
Did not work
prompt echo select * from Tickets limit 1; | mysql mydb res
prompt cat res
id EffectiveId Queue TypeIssueStatement Resolution
Owner Subject InitialPriority FinalPriority PriorityStatus
TimeWorked TimeLeftToldStarts Started Due
I did that before with a switch , just forgot
On Tue, 3 Jun 2003, Cal Evans wrote:
use a smaller font. This is really a function of your shell or client, not
MySQL.
humbly,
=C=
* Cal Evans
* http://www.christianperformer.com
* Stay plugged into your audience
* The measure of a
At 10:52 -0500 6/3/03, Steve Marquez wrote:
I have a links page that has categories.
I am attempting to place category links on one side, and the actual links on
the other.
However when I do this, I get the following result:
category1
category1
category1
category2
Here is the code I am using:
At 11:57 -0400 6/3/03, Asif Iqbal wrote:
something like this
++-+---++++---+---+-+
| id | EffectiveId | Queue | Type | IssueStatement | Resolution | Owner
| Subject | InitialPriority |
Asif,
If I understand you correctly, you should just be able to increase
the size of the DOS window (Of course this would have to be on Windwos).
If so simply right click the Title Bar and Choose Properties, then on the
Layout Tab increase the Window Size and Screen Buffer size
Hope
Hi there,
I have a problem with LOCKs. I use InnoDB tables and transactions.
[EMAIL PROTECTED] ~ 1001:0 /usr/local/libexec/mysqld --version
/usr/local/libexec/mysqld Ver 4.0.13 for portbld-freebsd4.8 on i386
[EMAIL PROTECTED] ~ 1002:0 uname -sr
FreeBSD 4.8-RC
[EMAIL PROTECTED] ~ 1003:0 httpd
Fabio,
I have had to do this quite a few times myself.
If you have use of a server with MySQL on it then it can be done using a GUI
(I use MySQL-Front, but most people seem to MySQL Control Center.
All you do is use the built-in tools to transfer table structures + data to
a database (any) on the
Use it after the grant command:
flush privileges;
hi everybody...
i just installed mysql 4.0.13 on a redhat linux 8.0
when i create a database as root and then grant privileges to another user
like this:
GRANT ALL ON somedb.* TO [EMAIL PROTECTED] IDENTIFIED BY passwd;
Allann J.
--
--
It worked.
Thanks!
-Steve
At 10:52 -0500 6/3/03, Steve Marquez wrote:
I have a links page that has categories.
I am attempting to place category links on one side, and the actual links on
the other.
However when I do this, I get the following result:
category1
category1
category1
Hello,
I'm trying to code a small C client, under windows, with bloddshed Dev-C++,
and i always get an error.
/* Code */
#include conio.h
#include stdarg.h
#include winsock.h
#include stdio.h
#include stdlib.h
#include string.h
#include mysql.h
int main(void) {
MYSQL* toto;
toto =
MySql returns data on a record basis and you are asking it to take a line's
worth of data from two records (the column header output is like a record)
and display it and then take the next line's worth of data from the same two
records and display it and repeat until the data from those records
Character set
In windows 2000 latin1
In Linux hosting latin1
Character sets
In windows 2000
latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis dec8 dos german1 hp8 koi8_ru
latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr
greek win1250 croat cp1257
Anthony,
As Bruce noted, you can greatly improve efficiency by using a WHERE clause,
but as you may be quoting a first formula I posted 'from first principles',
but which gives inaccurate results, I ought to correct it. Here is a much
more accurate formula for distance in miles...
3963 *
The pager option can be used to accomplish this (if you don't mind having things
running through, e.g., less). When I need to do this I just do:
mysql \P less -S
mysql my query here
You'll get unwrapped output (the -S option to less tells it to truncate rather
than wrap over-long lines).
You
the syntax for foreign key creation is different than what you have. You
need an alter table statement.
create table bar (
bar_idint unsigned auto_increment primary key,
foo_idint unsigned,
bar_value int,
) type=innodb;
alter table bar add constraint foreign key (foo_id)
That works with \G switch , but without the \G switch Istill get it
wrapped
wish I can remeber the switch
On Tue, 3 Jun 2003, Chris Tucker wrote:
The pager option can be used to accomplish this (if you don't mind having things
running through, e.g., less). When I need to do this I just do:
# [EMAIL PROTECTED] / 2003-06-03 18:45:31 +0200:
Executing gcc.exe...
gcc.exe U:\mep\Dev\abr.c -o U:\mep\Dev\abr.exe
-IC:\Dev-Cpp\include -IC:\mysql\include -LC:\Dev-Cpp\lib
C:\DOCUME~1\badier1\LOCALS~1\Temp/ccW8.o(.text+0x1d2):abr.c: undefined
reference to [EMAIL PROTECTED]'
At 18:45 +0200 6/3/03, [EMAIL PROTECTED] wrote:
Hello,
I'm trying to code a small C client, under windows, with bloddshed Dev-C++,
and i always get an error.
/* Code */
#include conio.h
#include stdarg.h
#include winsock.h
#include stdio.h
#include stdlib.h
#include string.h
#include mysql.h
int
What platform are you on? If you're on windows you probably won't have less
installed, in which case you'll need to either (a) install it or (b) use a
different pager (not sure what you'll have with windows, you'd have to
independently research it). I'm assuming that what you want is to have
From: [EMAIL PROTECTED]
Date: 2003/06/03 Tue AM 11:45:31 CDT
To: [EMAIL PROTECTED]
Subject: C API
Hello,
I'm trying to code a small C client, under windows, with bloddshed Dev-C++,
and i always get an error.
/* Code */
#include conio.h
#include stdarg.h
#include winsock.h
I am on solaris 2.8 sparc. You less works fine if I use \G switch. But I
want (as you explained) list of column names in one line in first row and
the results are thereafter in single rows instead of getting wrapped.
Like I said wish I remebered the swithc for that
On Tue, 3 Jun 2003, Chris
Hello,
I have a need for fast copying of a specific table from a master mysql
server to a number of slave servers (say 5).
The database in question could potentially have up to 2000 tables, and
at any time, one of those tables would need to be copied to all 5 of the
slaves, upon command of the
Are you using the -S switch to less? Note that it's a capital S, not lower
case. Does the output get properly sent through the less pager (i.e do you have
to page through the results that get selected)? Check the manpage for less on
your machine and find out what the truncate lines option
Hello,
I gave the follow commands to make the binary form in cygwin:
autoconf configure.in
./configure
and the messages were:
loading cache ...
bla bla bla
checking build system type... i686-pc-cygwin
configure: 724: Syntax error: word unexpected (expecting ))
Maybe the cause is the linefeeds
---Original Message-
--From: Ross Simpson [mailto:[EMAIL PROTECTED]
--Sent: Tuesday, June 03, 2003 10:31 AM
--To: [EMAIL PROTECTED]
--Subject: table copying/replication
--
--Hello,
--
--I have a need for fast copying of a specific table from a master
mysql
--server to a number of slave
Since this in running in Windows, I don't think you will have much luck in
a simple console display. While you can change size properties for Window
and Screen Buffer, these sizes are ONLY for length and you can't really do
much for horizontal size.
What I'd suggest tying is to run mysql as a
can anybody explain this to me please! I search am searching through a database
with first name and last names. BTW I use mysql 4.0.13 on RedHat Linux 9.0 in
case that matters. I created a fulltext search on both fields together so I can
search them like this:
mysql SELECT first_name,last_name
Hello
I use SQLyog at http://www.webyog.com/sqlyog. It has a
great facility to do exactly what you want. Just
connect to two differt servers and choose DB-Copy
Database To Another Host/DB option...and wholla you
are done.
Karam
--- Paul Najman [EMAIL PROTECTED] wrote:
Fabio,
I have had to
If you check the documentation about mysqldump, you'll find the command line
syntax for using a combination of mysqldump on the source machine and mysql
pumping to the target machine. It's simple, fast and everything is there
to work just fine.
-Original Message-
From: Paul Najman
User ORDER BY First Name
Chris Wilkinson wrote:
can anybody explain this to me please! I search am searching through a database
with first name and last names. BTW I use mysql 4.0.13 on RedHat Linux 9.0 in
case that matters. I created a fulltext search on both fields together so I can
search
Hello,
I was wondering if anyone has experienced moving a MySQL database from
Linux/Intel X86 to Mac OS X?
I plan to use mysqldump of course. I was only wondering if anyone has
run into problems they might share.
Thanks.
Greg
__
Do you Yahoo!?
Yahoo! Calendar
I have a mysql table column called 'imagecolumn' The rows contain links i.e.
image.gif
image.gif
null
image.gif
image.gif
To display in my web page im using:
img src=?php echo $row_Recordset1['imagecolumn']; ?
This displays the above images in my html page
The problem i have is where the
At 13:11 +0100 6/3/03, Chris Wilkinson wrote:
can anybody explain this to me please! I search am searching
through a database
with first name and last names. BTW I use mysql 4.0.13 on RedHat Linux 9.0 in
case that matters. I created a fulltext search on both fields
together so I can
search
Chris,
You're nearly there - the way to do it is:
SELECT first_name,last_name,MATCH(first_name,last_name) AGAINST
('+wilkinson* chris*' IN BOOLEAN MODE) AS score FROM names_table WHERE
MATCH(first_name,last_name) AGAINST ('+wilkinson* chris*' IN
BOOLEAN MODE) ORDER BY score DESC;
The db engine
Chris,
I should have added that the explanation is that the full text query does
not automatically sort on the score when boolean mode is selected.
Andy
-Original Message-
From: Chris Wilkinson [mailto:[EMAIL PROTECTED]
Sent: 03 June 2003 13:12
To: [EMAIL PROTECTED]
Subject: full
Not that particular move, but have used mysqldump/mysql combo to move
between linux--windows and back. Works well.
-Original Message-
From: Greg Grasmehr [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 03, 2003 1:19 PM
To: [EMAIL PROTECTED]
Subject: Red Hat linux database to Mac OS X
Hello,
I was wondering if anyone has experienced moving a MySQL database from
Linux/Intel X86 to Mac OS X?
I plan to use mysqldump of course. I was only wondering if anyone has
run into problems they might share.
You can't use BDB tables.
Thanks.
Greg
--
Paul DuBois
http://www.kitebird.com/
At 19:20 +0100 6/3/03, Daniel Crompton wrote:
I have a mysql table column called 'imagecolumn' The rows contain links i.e.
image.gif
image.gif
null
image.gif
image.gif
To display in my web page im using:
img src=?php echo $row_Recordset1['imagecolumn']; ?
This displays the above images in my
In InnoDB you *must* put an index on foreign keys. It doesn't do this
for you automatically.
You can do it in one statement:
create table bar (
bar_idint unsigned auto_increment,
foo_idint unsigned,
bar_value int,
constraint bar_pk primary key (bar_id),
index (foo_id),
keep the lines at or under 72 characters, please.
# [EMAIL PROTECTED] / 2003-06-03 19:20:17 +0100:
To display in my web page im using:
img src=?php echo $row_Recordset1['imagecolumn']; ?
This displays the above images in my html page
The problem i have is where the field in my
Carlos,
Character set
In windows 2000 latin1
In Linux hosting latin1
Character sets
In windows 2000
latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis dec8 dos german1 hp8 koi8_ru
latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr
greek win1250
You'll have to check if the result is NULL or not. Try this
? echo ($row_Recordset1['imagecolumn'] != NULL ||
($row_Recordset1['imagecolumn'] != ) ? img
src=\.$row_Recordset1['imagecolumn'].\ : ; ?
This is print out nothing if your result is equal to null.
On another notes, how do you
Hello,
Egor Egorov wrote:
I even flushed the privileges and restarted the MySQL server.
Any idea?
Please, show me the structure of table 'user'.
I found it.
Create_tmp_table_priv was Y.
thanks anyway,
elian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Hi -
Can anyone give the command line syntax for optimizing the entire db?
thanks in advance.
MS
I have been having a problem with MySQL lately. Specs are:
RedHat Linux 7.3
MySQL 3.23.56, for pc-linux (i686) (same behavior with 4.0.12 as well)
Apache 1.3.27
PHP 4.3.2
(most (99%) of the MySQL connections are made through PHP scripts
running as an apache module)
The problem happens as such:
Hi,
Please can someone help with advise on setting up a Secure MySQL Connection. The
details are as follows.
I have built and configured OpenSSL 0.9.7 and MySQL 4.0.12.
MySQL was configured with the options
./configure \
--enable-local-infile \
Roman,
you can use SHOW INNODB STATUS to look what active transactions you have and
how many lock structs they have.
Also innodb_lock_monitor helps.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Transactions, foreign keys, and a hot backup tool for MySQL
Order MySQL technical
FWIW, there is a PHP-DB mailing list that might prove more helpful to you. I
know certain folk on both lists can get mighty annoyed when an off-topic
question is posted, so I thought I'd give you a heads-up.
[EMAIL PROTECTED]
Edward Dudlik
Becoming Digital
www.becomingdigital.com
-
I think I need a MySQL code guru...
I am using the 4.0.12 client library on a Win2k host to
connect to a 4.0.13 linux server.
If I connect directly to the server using mysql_real_connect, everything
runs fine.
However, I want to use SSH tunneling.
So I set up a SSHv2 tunneling connection from
You can use this script that I wrote. Also you can change OPTIMIZE TABLE
with ANAYLIZE TABLE
#!/usr/bin/perl -w
# If you use this give me CREDIT!! :) Dathan Vance Pattishall
#
use strict;
use DBI;
use lib '/site/lib';
my $USER = ;
my $PASSWD = ;
my ($host,$DB,$TABLE) = @ARGV;
die must specify
And you are completely wrigth. There is no MySql
problem.
I solved the problem but I did not gave you all the
necessary information.
In the middle of all the problem there is also a php
application, apache and the OS so I was confused.
The problem was with php.
In php.ini there is the following
You shouldn't have any problems if you are using mysqldump. I've used
it plenty of times on OSX.
On Tuesday, June 3, 2003, at 02:19 PM, Greg Grasmehr wrote:
Hello,
I was wondering if anyone has experienced moving a MySQL database from
Linux/Intel X86 to Mac OS X?
I plan to use mysqldump of
I've used a simply shell script in the past.. run from cron to do it...
I just see someone posted a perl solution.. I've used a php one aswell..
#!/bin/sh
# DB OPTIMIZE SCRIPT - !! WARNING, DOES TABLE LOCKING DURING OPTIMIZES
user=root
pass=secret
host=10.1.1.1
db=mydb
[EMAIL PROTECTED]
Mark,
Can anyone give the command line syntax for optimizing the entire db?
thanks in advance.
mysqlcheck [OPTIONS] --databases DB1 [DB2 DB3...]
This program can be used to CHECK (-c,-m,-C), REPAIR (-r), ANALYZE (-a)
or OPTIMIZE (-o) tables. Some of the options (like -e or -q) can be
used at
?php
if($row_Recordset1['imagecolumn']) echo 'img
src='.$row_Recordset1[imagecolumn].'';
?
Peter
-Original Message-
From: Becoming Digital [mailto:[EMAIL PROTECTED]
Sent: 03 June 2003 20:57
To: [EMAIL PROTECTED]
Subject: Re: Mysql / PHP image link problem.
FWIW, there is a PHP-DB
Thanks for the reply.
I didn't explain properly :)
A diagram should help:
||
|-| 1 || 2 | ||
|stage| -- |prod| -- |-| ||
|-| || |-|replicas|
||
'stage' is a staging mysql instance,
yes, quite right. thanks for pointing that out.
jeff
Kevin Fries wrote:
In InnoDB you *must* put an index on foreign keys. It doesn't do this
for you automatically.
You can do it in one statement:
create table bar (
bar_idint unsigned auto_increment,
foo_idint
Hi,
Assuming that this system runs on *nix and that prod is set up to
replicate to all the replicas you could write a small bash script to push
the data from the stage to the prod which would then replicate as
normal.
I would author the script something like this...
[bash]# mysqldump -e -hstage
I've just done a similar thing. Are you sure that you are running the
mysql client that you have just compiled.
I used the following build options
CFLAGS=-O3 CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions
\
-fno-rtti ./configure \
--enable-assembler \
I looked at that type of idea, and the reason I didn't mention it was
the indexes -- each table involved has ~5 indexes, and on a large table,
that equals a lot of work that's already done on 'stage' that must be
redone on 'prod'. I'd really like to preserve the indexes from stage if
at all
Hi Allann, Ajos, Mysql List members
As far as I know the flush privileges is not necessary when using GRANT.
flush privileges is only used after you updated the privilege database mysql
manually using INSERT or UPDATE.
Somebody please correct me if I am wrong.
Best regards
Nils Valentin
OK - in that case there's not much you can do with replication... But with
mysql you could write some bash to copy the raw files over like:
Run this from /datadir (on the server you want to copy from):
tar cf - databasedirname | ssh server_you_want_it_to_go_to 'cd /datadir; tar
xf -'
And
Hi,
Please excuse me if this question has been discussed before.
Is there a way to securely setup 2 MySQL Servers to be in sync with each
other?
Let's say that I have server A at home and Server B at my work and I
want server be to mirror exactly what I do on Server A.
Can this be done?
Is
I would like to limit the amount of characters that appear on a PHP page,
using PHP.
Here is the code that I am using:
?php
echo b$title/b\nbr;
echo $author\np;
echo $article_contents['LimitChars'];
?
This code works, however it limits the characters to one
Assuming that you speak english - you can do the following...
http://www.mysql.com/doc/en/Replication.html
Cheers,
Andrew
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday 04 June 2003 00:24
To: [EMAIL PROTECTED]
Subject: MySQL Mirroring.
Hi,
My Message was in English.
Thank you for your help.
On Wed, 4 Jun 2003 00:33:10 +0100 , Andrew Braithwaite
[EMAIL PROTECTED] wrote:
Assuming that you speak english - you can do the following...
http://www.mysql.com/doc/en/Replication.html
Cheers,
Andrew
-Original Message-
From:
Hi,
I want to make a HEAP table which must contain somewhat large text (at
least larger than 255 chars), but I need to store a little more data. Is
it somehow possible to have a column in a heap table which can contain
more than 255 bytes? (I'm thinking of not pretty much more like 1024
Hi,
I recently posted an email about 'Inoperable Symbolic Links in Win2K Pro '
and I subsequently subscribed to the belief that MySQL would fail when
installed in a location that was different that the default location. I
tried a myriad of things to get the database system to function correctly.
Hi Charles,
Having spoken to somebody from MySQL AB in person last month here in Tokyo I
know that the problem seems to be adressed currently. What I dont know is
when, how and which new mechanism will be applied to the mailing list.
Best regards
Nils Valentin
Tokyo/Japan
2003 6 4
At 10:10 +0900 6/4/03, Nils Valentin wrote:
offlist
Hi Paul,
did I get something wrong or did you actually mean
mysql SELECT VERSION(); instead of mysql SHOW VERSION(); ???
You're right, I'm wrong. SELECT VERSION();
(In case I am right, I didnt post as I thought is not so polite to
1 - 100 of 143 matches
Mail list logo