troubleshooting Question

backup mysql db like webAdmin

Avatar of prowebinteractiveinc
prowebinteractiveinc asked on
PHP
13 Comments1 Solution339 ViewsLast Modified:
I would like to create a php function to export the structure and data from my mySQL db   and save it as file.sql.

I will then add this function to my list of scheduled tasks

I am using the following to connect to the db:
	function dbConnect()
	{
		$mysql_local = ""; 
		$mysql_db = ""; 
		$db_user = ""; 
		$db_user_pass = "";		
		if(!isset($oConn))
		{
			$oConn = @mysql_pconnect($mysql_local,$db_user,$db_user_pass) or die ("Could not connect to local server");
			mysql_select_db($mysql_db) or die ("Unable to select database");				
		}
	}

	function dbDisconnect()
	{
		if(isset($oConn))
		{
			mysql_close ($oConn);
		}		
	}

Thanks
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 13 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 13 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros