•
•
•
•
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
![]() |
•
•
Join Date: Mar 2008
Posts: 2
Reputation:
Rep Power: 0
Solved Threads: 0
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
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
•
•
Join Date: Mar 2008
Posts: 2
Reputation:
Rep Power: 0
Solved Threads: 0
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??
•
•
Join Date: Dec 2007
Posts: 114
Reputation:
Rep Power: 1
Solved Threads: 14
If you have created .sql file with mysqldump or exported via phpMyAdmin, simply type the following command on command prompt
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.
mysql -uMYSQL-USERNAME -p database_name < database.sql
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.
![]() |
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Similar Threads
- Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource (PHP)
- Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result (PHP)
- Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource (PHP)
- Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource (MySQL)
- Warning: mysql_fetch_array(): (PHP)
- Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource (PHP)
- Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource (PHP)
Other Threads in the MySQL Forum
- Previous Thread: Connecting A Website To a DataBase
- Next Thread: HELP BUILDING DATABASE!!


Linear Mode