I have WebMatrix beta 2. I made a WordPress site on my local box. I published it using FTP (my hosting does not offer "web deploy"). Of course this means my "MySQL" database was not published. So I want to export it separately, and import it manually.
However, I can't find any option in Webmatrix that allows the database to be exported.
Can someone explain how that is done with Webmatrix?
You cannot "upload" your Mysql database , you need to get the schema in a sql file , then on the remote server ,use a tool to execute the sql file to fill the remote database.
you can do it with phpmyadmin , get it , unzip in on your local server , select your wordpress local database then choose export to sql file.
next , if your distant hosting service may already provide an instance of phpmyadmin. use it to import back your datas.
There may be a plugin in wordpress that can help , but since i'm more a drupal guy , i cant help you on that matter.
Mystagogue
Member
16 Points
9 Posts
Export Database through WebMatrix
Nov 06, 2010 11:19 PM|LINK
I have WebMatrix beta 2. I made a WordPress site on my local box. I published it using FTP (my hosting does not offer "web deploy"). Of course this means my "MySQL" database was not published. So I want to export it separately, and import it manually. However, I can't find any option in Webmatrix that allows the database to be exported.
Can someone explain how that is done with Webmatrix?
webmatrix Database Beta 2
camus
Member
209 Points
66 Posts
Re: Export Database through WebMatrix
Nov 07, 2010 08:43 PM|LINK
You cannot "upload" your Mysql database , you need to get the schema in a sql file , then on the remote server ,use a tool to execute the sql file to fill the remote database.
you can do it with phpmyadmin , get it , unzip in on your local server , select your wordpress local database then choose export to sql file.
next , if your distant hosting service may already provide an instance of phpmyadmin. use it to import back your datas.
There may be a plugin in wordpress that can help , but since i'm more a drupal guy , i cant help you on that matter.
SimpleBlogCms powered by Razor and WebMatrix