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