Chris,
That is very weird, and I don't have any real help :-(
but there are a couple of things I will suggest:
1. Run mysiamchk (assuming these are MyISAM tables) from the Solaris box
and retry, its "possible" that there is a character in your data that the
Windows box is allowing, but Solaris is dying over.
2. You may want to try is to see if this happens on another *nix platform
if you can get your hands on one. See if you have the same problem on a
Linux box, if not then try moving the data from the Linux box to the Solaris
box.
3. If you still have no luck check the compile time options to see if there
was any weirdness or try and recompile.
I have moved data from an NT 4.0 server to a Redhat Linux server to a
Solaris 2.7 box, without a single problem, so I know there isn't normally a
problem doing this. Anyone is welcome to jump in at this point, I can feel
the water getting deeper :-)
Scott Helms
Director of Technology, ZCorum
(770) 888-8900 ext 2205
----- Original Message -----
From: "Alexander, Chris" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 25, 2002 12:21 PM
Subject: RE: Problem loading PC DB into Solaris
>
> |
> | Can you access the Solaris DB from your Windows box?
> |
> | mysql -u <user> -h <ip_of_solaris_box> -p
> |
>
> Yep.
>
> | Also, what is the error your getting exactly? Are you
> | running the web
> | server on the Solaris box as well? If so drop this into
> | the document root:
> | <?
> | phpinfo();
> | ?>
> |
> | and call it something original like info.php, and call it
> | from a browser.
> | It should show the mysl support section.
>
> Apache/PHP/Mysql on the Sol 2.6 box (Generic_105181-26). Yes,
> paleo-computing but I don't think that is the problem.
>
> If I empty the data and keep the schema (i.e. start with a
minimal-populated
> DB) it works...
>
> In phpinfo() the mysql section looks like this:
>
> MySQL Support enabled
> Active Persistent Links 2
> Active Links 2
> Client API version 3.23.39
> MYSQL_MODULE_TYPE builtin
> MYSQL_SOCKET /tmp/mysql.sock
> MYSQL_INCLUDE
> MYSQL_LIBS
>
> Directive Local Value Master Value
> mysql.allow_persistent On On
> mysql.default_host no value no value
> mysql.default_password no value no value
> mysql.default_port no value no value
> mysql.default_socket no value no value
> mysql.default_user no value no value
> mysql.max_links Unlimited Unlimited
> mysql.max_persistent Unlimited Unlimited
>
> Hmm, include and libs is empty...can't see that being the issue though.
This
> is all stuff as set (default?) from the Sol 2.6 mysql package at
> sunfreeware.com.
>
> The PHP error I am getting is:
>
> Warning: Supplied argument is not a valid MySQL result resource in
> /www/sapdoc.rmoc.on.ca/html/lib/db.php on line 69
>
> Which normally means the select from the db was malformed, but I can't see
> where it is broken, and this exact same code works on the "identical" db
> that is on the PC via a socket connection (but throws this error when data
> is called from localhost).
>
> Weird.
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
