User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 427,218 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,191 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser: Programming Forums
Views: 936 | Replies: 3
Reply
Join Date: Mar 2008
Posts: 2
Reputation: vinnyqua is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
vinnyqua vinnyqua is offline Offline
Newbie Poster

Warning: mysql_fetch_array

  #1  
Mar 7th, 2008
I had my site working which require mysql database... so now im trying to host that site here at home... my site comes up but now on the top of the main site 3 errors come up...

Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'milatcom_clipsha'@'localhost' (using password: YES) in /www/www.mysitesname.com/include/adodb/drivers/adodb-mysql.inc.php on line 227

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/www.mysitesname.com/include/function.php on line 565

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/www.mysitesname.com/include/function.php on line 565

thanx,
vinny
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Dec 2007
Posts: 114
Reputation: mwasif is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 14
mwasif mwasif is offline Offline
Junior Poster

Re: Warning: mysql_fetch_array

  #2  
Mar 7th, 2008
You are providing an invalid mysql username password or the mysql user does not have priviliges to connect to the database.
Reply With Quote  
Join Date: Mar 2008
Posts: 2
Reputation: vinnyqua is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
vinnyqua vinnyqua is offline Offline
Newbie Poster

Re: Warning: mysql_fetch_array

  #3  
Mar 7th, 2008
i had this site working with a web hoster now im trying to get it up and running on my home web server, running mac os x server... i got mysql running... and i have a backup database file from my old web hoster... its a .sql file.... im guessing i have to restore it... how exactly would i go on doing that??
Reply With Quote  
Join Date: Dec 2007
Posts: 114
Reputation: mwasif is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 14
mwasif mwasif is offline Offline
Junior Poster

Re: Warning: mysql_fetch_array

  #4  
Mar 7th, 2008
If you have created .sql file with mysqldump or exported via phpMyAdmin, simply type the following command on command prompt
mysql -uMYSQL-USERNAME -p database_name < database.sql
Replace MYSQL-USERNAME with a valid mysql username. On hitting enter, it will ask for Mysql username password.

After importing the data, create a valid username which can access your site database. Provide this username and password in your site connection parameters.
Read this page for detail information about exporting and importing .sql files.
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb MySQL Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Similar Threads
Other Threads in the MySQL Forum

All times are GMT -4. The time now is 11:14 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC