mysql database backup from server to the local machine
-
Hi, I have to take backup of the mysql database from the server to local machine database using asp.net 2.0. I have established the connection to the server database using the server name,username,password. Now i need to connect the local machine database. I have used the server name as 'localhost',username'root',pwd 'root' But its not establishing the connection to the local machine when i upload the code in the server. Can Anyone give me an idea how to connect to the local machine. Thanks
-
Hi, I have to take backup of the mysql database from the server to local machine database using asp.net 2.0. I have established the connection to the server database using the server name,username,password. Now i need to connect the local machine database. I have used the server name as 'localhost',username'root',pwd 'root' But its not establishing the connection to the local machine when i upload the code in the server. Can Anyone give me an idea how to connect to the local machine. Thanks
sbua wrote:
But its not establishing the connection to the local machine when i upload the code in the server.
um... You're using localhost, because your DB is local to you, but you're running the code on the server ? Have I got it wrong, or is this a joke ?
Christian Graus Driven to the arms of OSX by Vista.
-
sbua wrote:
But its not establishing the connection to the local machine when i upload the code in the server.
um... You're using localhost, because your DB is local to you, but you're running the code on the server ? Have I got it wrong, or is this a joke ?
Christian Graus Driven to the arms of OSX by Vista.
-
Hi, I tried to take the backup of mysql server database to my local database. I dont know how to do this. Could you please give me an idea to implement this. Thanks
Where is this ASP.NET application running? Server or your local machine? If it is on server, you are out of luck. :)
Navaneeth How to use google | Ask smart questions
-
Where is this ASP.NET application running? Server or your local machine? If it is on server, you are out of luck. :)
Navaneeth How to use google | Ask smart questions
-
Hi, Asp.net application is running in the server. How to take my server db backup to the local machine Thanks
You have no idea about how things works. How are you expecting the application running on a remote server can communicate with your local machine?
Navaneeth How to use google | Ask smart questions
-
Hi, I have to take backup of the mysql database from the server to local machine database using asp.net 2.0. I have established the connection to the server database using the server name,username,password. Now i need to connect the local machine database. I have used the server name as 'localhost',username'root',pwd 'root' But its not establishing the connection to the local machine when i upload the code in the server. Can Anyone give me an idea how to connect to the local machine. Thanks
This is a tricky question. You can use wscript to run shell commands and get this done.
Dim oShell
Set oShell = CreateObject("WScript.Shell")
oShell.run "cmd /C " & strMYLocation & "mysqldump -B " & dbname & " -u " & strMYUser & " -p" & strMYpassword & " > " & strMYBackup & "dbBkup" & strBackup & dbname & ".sql",,trueSet oShell = Nothing
Make sure to grant read/execute/write permissions to the IUSR account over all the involved files and folders. Good luck!
Ranjit Viswakumar Professional Services Specialist http://hostmysite.com/?utm\_source=bb