Chris,
Can you access the Solaris DB from your Windows box?
mysql -u <user> -h <ip_of_solaris_box> -p
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.
Scott Helms
----- Original Message -----
From: "Alexander, Chris" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 25, 2002 11:34 AM
Subject: RE: Problem loading PC DB into Solaris
> Yep, all that stuff works. I can list the contents of any table, etc.
>
> One thing I did notice is that in phpMyAdmin that the total sizes of both
> tables are different - out by a few kb for some of the larger tables with
> the Solaris ones being smaller.
>
> I dunno, it's weird - the mysql selects that are in the PHP should be
> ignoring that level of stuff anyway...if it wasn't for the solaris box
being
> able to use the pc tables cleanly I wouldn't have started looking at mysql
> being the problem. The php looks clean and it does work properly on the pc
> data when run from solaris.
>
> Weirdness. :(
>
> | -----Original Message-----
> | From: Scott Helms [mailto:[EMAIL PROTECTED]]
> | Sent: Monday, March 25, 2002 11:40 AM
> | To: Alexander, Chris; [EMAIL PROTECTED]
> | Subject: Re: Problem loading PC DB into Solaris
> |
> |
> | Chris,
> |
> | The first thing to do is try and access the data from
> | the database on
> | the Solaris box. This will show you if there is a problem
> | with MySql. As
> | for the data, there isn't anything you need to do it
> | "except" make sure the
> | permissions are correct on the data directory and its
> | contents. Try this
> | from the Solaris box,
> | mysql -u <username_for_webapp> -p
> | Enter password:<webapp's_password>
> | mysql> show databases;
> | +-----------------------+
> | | Database |
> | +-----------------------+
> | | <your_database> |
> | | mysql |
> | | test |
> | +-----------------------+
> | 3 rows in set (0.01 sec)
> | mysql> use <your_database>;
> | Reading table information for completion of table and column names
> | You can turn off this feature to get a quicker startup with -A
> |
> | Database changed
> | mysql> show tables;
> | <lists all of your tables>
> |
> | Then try a simple select, like:
> | select * from <small_table>;
> |
> | If all of this works then the problem probably isn't MySql,
> | however, I think
> | you will identify the problem before reaching the end :-)
> |
> | Scott Helms
> | Director of Technology, ZCorum
> |
> |
> |
> | ----- Original Message -----
> | From: "Alexander, Chris" <[EMAIL PROTECTED]>
> | To: <[EMAIL PROTECTED]>
> | Sent: Monday, March 25, 2002 11:01 AM
> | Subject: Problem loading PC DB into Solaris
> |
> |
> | >
> | > Hi All! New list member here.
> | >
> | > I was wondering if I could get a little help with a
> | problem I am having
> | when
> | > I load a databse into a Solaris mysql instance.
> | >
> | > I had populated a database that acts as a content
> | repository for a web
> | site
> | > on my personal PC (Windows) as a proof of concept. The
> | site works fine in
> | > this environment.
> | >
> | > I have since gotten approval to move the site to one of
> | our Solaris
> | servers
> | > (Sol 2.6).
> | >
> | > I have tried various methods of moving the database from
> | the PC to the
> | > Solaris system: copying the files directly, using backup,
> | restore, import,
> | > etc. directly from one mysql to another, using data and
> | schema exports
> | from
> | > within phpMyAdmin. In each instance I still come up with
> | the standard PHP
> | > invalid resource error once I attempt to load the web site.
> | >
> | > Sounds like a PHP problem, right? That's what I thought
> | too until I
> | > connected directly to the database on my PC as opposed to
> | the one local to
> | > the Solaris box. Everything works fine! Additionally, I
> | have not altered
> | any
> | > of the PHP scripts.
> | >
> | > I was wondering if there was some kind of processing of
> | the data that must
> | > be done when moving the data from a PC MySQL to a Solaris
> | MySQL? I didn't
> | > think there would be but that is kind of what it is
> | looking like to me at
> | > this point. When I browse the table from mysql or from
> | phpMyAdmin they
> | look
> | > identical as far as I can tell visually.
> | >
> | > Any insights or help appreciated.
> | >
> | > Thanks!
> | >
> | >
> | ------------------------------------------------------------
> ---------
> | > 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
>
---------------------------------------------------------------------
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
