BG Mahesh wrote:
hi
How do I import data from Dbase3 into MySQL?
--
B.G. Mahesh
[EMAIL PROTECTED]
http://www.indiainfo.com/
BG,
There are tools you can use to migrate it to mysql, i use it before that
i get it in the forum. You can search some forum indicating the
migration tools for DB3, Foxp
hi
How do I import data from Dbase3 into MySQL?
--
B.G. Mahesh
[EMAIL PROTECTED]
http://www.indiainfo.com/
--
__
IndiaInfo Mail - the free e-mail service with a difference! www.indiainfo.com
Check out our value-added Premium features, such as an ext
Hi Kaan
try
Page 1
$testArray[0] =Apple;
$testArray[1] =Banana;
$testArray[2] =Peach;
$testA=implode("!", $testArray);
echo "";
Page2
$testArray=explode("!", $kcompany);
echo $testArray[1];
HTH
Steve
PartyPosters wrote:
Hello,
Please can someone tell me how you pass arrays between PHP pages.
I ha
Or you can issue session_start() at the top of each page, assign your
array to $_SESSION[] in one page, and pluck it from the session array
in the other page.
(But you asked the question in the wrong forum)
PB
-
Mike Johnson wrote:
From: PartyPosters [mailto:[EMAIL PROTECTED]]
Not necessary to change my.cnf, unless --skip-networking was specified.
Also assuming that you are using port 3306.
mysql> show variables like 'port';
+---+---+
| Variable_name | Value |
+---+---+
| port | 3306 |
+---+---+
1 row in set (0.0
One other thing to check, make sure --skip-networking isn't specified in
your configuration.
mysql> show variables like 'skip_networking';
+-+---+
| Variable_name | Value |
+-+---+
| skip_networking | OFF |
+-+---+
1 row in set (0.00
When you are running as root, but are you running as 'root'@'%' or
'root'@'localhost'? This does make a big difference. The '%' means all
network connections, which isn't secure. I would only using it as testing
purposes.
However, because your error message says that you cannot see the server, ar
1) Are you running a firewall? If so, make sure that port 3306 is open.
2) Is your MySQL server is up and running?
3) Do you have the correct permissions to connect to the server via your
mysql.hosts table?
Just some thoughts.
J.R.
-Original Message-
From: gerardo Villanueva [mailto:[E
From: PartyPosters [mailto:[EMAIL PROTECTED]
> Hello,
> Please can someone tell me how you pass arrays between PHP pages.
> I have tried something like this and have tried many
> variations of this but
> nothing working yet ;
>
>
> Page 1
> $testArray[0] =Apple;
> $testArray[1] =Banana;
> $tes
I have mysql version 4.0.15-nt in a server NT, I can
connecting with mysql localy, but when i try remote
connection the error is:
"Error Number 2003 Can't connect to MySQL server on
'IP' (10060) " .
I use mysql odbc 3.51
Is necesary the file my.cnf in c:\my.cnf
Regards
Gerardo Campos
[snip]
Please can someone tell me how you pass arrays between PHP pages.
I have tried something like this and have tried many variations of this
but
nothing working yet ;
Page 1
$testArray[0] =Apple;
$testArray[1] =Banana;
$testArray[2] =Peach;
echo "";
Page2
echo $testArray[1];
[/snip]
Just in
Hello,
Please can someone tell me how you pass arrays between PHP pages.
I have tried something like this and have tried many variations of this but
nothing working yet ;
Page 1
$testArray[0] =Apple;
$testArray[1] =Banana;
$testArray[2] =Peach;
echo "";
Page2
echo $testArray[1];
Many Thanks.
One problem with that formula is that it fails if you wrap around from one
year to the next. But as a quickie, it's good.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Peter Brawley <[EMAIL PROTECTED]> wrote on 03/22/2005 01:01:29
PM:
> Michael,
>
> Someone on the list
Michael,
Someone on the list recently dave this quickie formula for computing
the no. of biz days::
DATEDIFF(date2, date1) - (WEEK(date2) - WEEK(date1)) * 2
PB
-
Stembridge, Michael wrote:
A table exists with id and datetime columns; I need to SELECT records from
the previous busi
At 10:28 AM 3/22/2005, [EMAIL PROTECTED] wrote:
What do you mean by "historical"? Are we talking 20th century dates or
something BCE?
Dates that could be a couple of years old.
-
Mike Rykowski
IT - Telecommunication and Network Services
(847) 467-7335
[EMAIL PROTECTED]
--
MySQL General Maili
According to the output of perror:
perror 5
Error code 5: I/O error
Are you having problems with your disk? Maybe syncing or bad sectors or
even something as simple as out of space?
Best of luck,
--V
Mihail Manolov wrote:
Have you seen this before:
mysqldump: Got errno 5 on write
I have start
Mike Rykowski <[EMAIL PROTECTED]> wrote on 03/22/2005 11:12:41 AM:
> Hello,
>
> I have historical dates in datetime format and they are in UTC. I'd
like
> to convert them to localtime. Can this be done with mysql 3.23.22? It
> looks like 4.1 can handle this, but I won't be upgrading in a whi
"Stembridge, Michael" <[EMAIL PROTECTED]> wrote on 03/22/2005 10:30:50
AM:
> A table exists with id and datetime columns; I need to SELECT records
from
> the previous business day. I began with this:
>
>
>
> SELECT id FROM table WHERE TO_DAYS(NOW()) - TO_DAYS(datetime) <=1
>
>
>
> Bu
Have you seen this before:
mysqldump: Got errno 5 on write
I have started getting this error recently in my email box - the message is
result of my daily backup cronjob.
Ideas?
rgrdz,
Mihail Manolov
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hello,
I have historical dates in datetime format and they are in UTC. I'd like
to convert them to localtime. Can this be done with mysql 3.23.22? It
looks like 4.1 can handle this, but I won't be upgrading in a while.
If not, does anyone know of a perl module that takes mysql formated
dateti
A quick try:
In most cases you need results from yesterday, but for Sunday and Monday we
must correct extra for the weekend.
DAYOFWEEK() returns 1 for Sunday, 2 for Monday, etc., so we can use this to
make a correction value:
SET @COR = (DAYOFWEEK(NOW()) < 3) * DAYOFWEEK(NOW());
SELECT * FROM ta
Z X C V <[EMAIL PROTECTED]> wrote on 03/21/2005 08:32:24 PM:
>
> Hello,
>
> Are there any good rfcs or other documents that would assist in the
> discussion I'm having with our organization's Oracle programmers in
> regards the following:
>
> Oracle DB -> MySQL
>
> They recommend:
>
> ~ col
A table exists with id and datetime columns; I need to SELECT records from
the previous business day. I began with this:
SELECT id FROM table WHERE TO_DAYS(NOW()) - TO_DAYS(datetime) <=1
But if NOW() is a Monday, it pulls records from Sunday (there are none since
records are inserted
On Tuesday, March 22, 2005 07:15, symbulos partners wrote:
> Dear friends,
>
> thanks for the link to the dev manual page on encryption function.
>
> Which encryption is more secure (strongest)
> AES
> DES
> SHA
> ?
Are you using this for password storage or encrypting actual data?
If you are
Dear friends,
thanks for the link to the dev manual page on encryption function.
Which encryption is more secure (strongest)
AES
DES
SHA
?
I would have said AES, but after reading the manual chapters on DES, SHA I am
not s(ec)ure any more.
By the way, I did not understand if the bug
http://b
Hello.
The manual recommends to use ALTER TABLE to increase the MAX_ROWS and
AVG_ROW_LENGTH table options values. See:
http://dev.mysql.com/doc/mysql/en/repair.html
CheHax <[EMAIL PROTECTED]> wrote:
> Hello there,
>
> I am receiving "Got error 136 from storage engine" and
Hello.
See:
http://dev.mysql.com/doc/mysql/en/encryption-functions.html
symbulos partners <[EMAIL PROTECTED]> wrote:
> Dear friends,
>
> where is the description of the functions md5 in the manual? where is the
> description of the function crypt()?
>
> are there are good altern
Hi
according to Dr Google I'm not the first one to encounter this error
below.
SpamAssassin: invoked with 'spamd -D -q -u filter'
failed to load user (filter) scores from SQL database: SQL Error:
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (13)
Thus, I cannot
Hi,
error 136 = No more room in index file
so I suppose it's a problem with the size needed for your keys, maybe that
will help:
http://dev.mysql.com/doc/mysql/en/key-space.html
HTH,
Melanie
From: CheHax <[EMAIL PROTECTED]>
Reply-To: CheHax <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Subject:
Hello there,
I am receiving "Got error 136 from storage engine" and I need some
light on this matter.
I have a table with 23,000,000 records and I want to update it with
datas from another one with the exact same amount of rows. The 2
tables can be linked by a primary key. Both tables are myISAM,
Shawn,
I like your idea very much. Unfortunately I am not using version 5 yet,
but this may hasten my upgrade.
My initial thought was to try and find a function like PostgreSQL's
LISTEN command
(http://www.postgresql.org/docs/8.0/interactive/sql-listen.html). But I
think this method is bette
31 matches
Mail list logo
