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
