mgreen81 Posted December 6, 2007 Share Posted December 6, 2007 Hi all, I was recently given the task of moving a MySQL database from an ageing server to a newer shiny one. The databse is used on our company's internal webpage (written in PHP) as a number generator for documents. On the PHP page, you should see 2 dropdown boxes, on which you can select project/document type from the MySQL database. You then click the submit button and it generates a unique document code. It works fine on the old server, but we are getting rid of that server in the new year. I setup PHP fine on the new server, and copied from the old server the database and pasted it in the correct place on the new server. I then copied/pasted the PHP webpages and updated the code/usernames/passwords to match the new server. Everything seems to be ok, and appears as it should except for the fact that the 2 dropdown boxes are empty. I know (well I presume) it is connecting to the database ok, becuase if I change the username or password in the php code to make it incorrect, the page just dispays a message saying that it cannot connect to the database. But why can I not see the data? Help please!....This is driving me nuts :-( Quote Link to comment Share on other sites More sharing options...
trq Posted December 6, 2007 Share Posted December 6, 2007 Can you access this database from mysql's command line interface? Is the old mysql server the same version as the new one? Quote Link to comment Share on other sites More sharing options...
mgreen81 Posted December 6, 2007 Author Share Posted December 6, 2007 no they are different versions of MySQL. How do i go about accesing the database via the command line interface? Thanks Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.