Hello, I want to export my Wordpress mySQL database/objects from my localhost to the mySQL database on discountASP.net and as I understand it I need a script to do that. I am on a mac (if that makes a difference) working with myPHPadmin, and have no "scripting" experience. Nor am I that versed with the aspnet interface or how the import/export would work. I have already uploaded the rest of the site through Filezilla, and though I can log into the WP dashboard for the site through the discountasp.net server, and the theme, php and css are there, the site does not display in the browser. Does anyone here have any pointers? Thanks, Sue
You might find this useful: http://codex.wordpress.org/WordPress_Backups It includes a step by step guide for backing up a WordPress db using phpMyAdmin (with screenshots) There's also http://codex.wordpress.org/Restoring_Your_Database_From_Backup - the restore which is the reverse of the backup process
Thanks CrystalCMS, for the feedback. I guess I should have mentioned before that I have a .sql backup already (from phpMyAdmin) on my localhost (mac). So my question is about uploading my .sql DB backup to the discountasp.net database for the Wordpress blog. I guess I need a script because they have no phpMyAdmin to import or export the .sql file. I've isolated a part of the info you sent that looks as if it applies to a script and mySQL... but it refers to bzip2 and .tar.gz files, not .sql. Also, even if it was referring to .sql, it is not clear to me where I am typing all of this since I cannot find on the discountasp.net server how to do much of anything with the database I've setup for this blog. It seems as if it should be so simple, and I guess if you're a programmer then it would be. I am, clearly, a newbie! Here's what I found on your links... 1. Unzip your .bz2 file: user@linux:~/files/blog> bzip2 -d blog.bak.sql.bz2 Note: If your database backup was a .tar.gz file called blog.bak.sql.tar.gz, then tar -zxvf blog.bak.sql.tar.gz is the command that should be used instead of the above. 2. Put the backed-up SQL back into MySQL: user@linux:~/files/blog> mysql -h mysqlhostserver -u mysqlusername -p databasename < blog.bak.sql Enter password: (enter your mysql password) user@linux~/files/blog:>
Ok since you already have a backup of the database and it's a SQL script (Structured Query Language data manipulation statements), the part of http://codex.wordpress.org/Restoring_Your_Database_From_Backup that would have applied to you is the 1st part with the title "Restore Process" that describes restoring a database using phpMyAdmin from a SQL script. Of course you need phpMyAdmin to follow this. When you say "they have no phpMyAdmin to import or export the .sql file" I assume you mean DiscountASP.NET has not pre-installed phpMyAdmin in your hosting account. If that's what you're saying then yes you're right - and you'd like to use phpMyAdmin to manage your db, then you'd need to upload, install and configure it yourself to get it working. If you want to go down that route then this might help you out: http://community.discountasp.net/showthread.php?t=12846 The are a few other ways to manage a mySQL database remotely - personally I prefer MySQL WorkBench..not that I'm much of a MySQL fan mind you.
Hi CrystalCMS, I was able to upload phpMyAdmin to the DASP.net server, and though the configuration looks different from the way my local host displays it, it looks as if the database tables are there. In fact, if I try to upload them again in won't let me saying that it's there. However, when I go to the web address of the WP blog I created there's nothing but a blank screen. I can log into the post, and the css style sheet, header.php, sidebar.php, index.php, plug ins, etc. However, nothing displays on the screen. The images that I uploaded to the WP site are not there. So, maybe I have something in the wrong place? This is the path for mySQL: http://example.com/subdirectory/phpMyAdmin-4.0.4-all-languages This is the path for the blog: http://example.com/subdirectory/blog (The discountaspnet application folder is the subdirectory). Hoping there's some glaring error you can see here. Thank you!
Sorry there's nothing there that gives me a clue to what's going on. Perhaps it would help if you could include the actual URL to your site.
Sorry.. I am adding three blogs to kaleidoscopepizza.com. An existing, mostly static site. They are in a subdirectory "KaleidoscopePizzeria" for now for testing. Here are two WP blogs that are already up and running on the dasp.net site. The one I am trying to upload (employee_schedule) would look about the same. The two blogs that work: http://kaleidoscopepizza.com/KaleidoscopePizzeria/Off_the_Menu/ http://kaleidoscopepizza.com/KaleidoscopePizzeria/Grateful_Deals/ Employee Schedule is the one I cannot get working: Path for the blog: http://kaleidoscopepizza.com/KaleidoscopePizzeria/employee_schedule/ Path for where I put phpMyAdmin: http://kaleidoscopepizza.com/KaleidoscopePizzeria/phpM...-all-languages (The discountaspnet application is assigned to the KaleidoscopePizzeria). Thank you!
Yes this is looking quite odd from here. I think it's fair to say that the html response returned from the 1st 2 working links can be identified as being generated by WordPress. However for the 3rd non working link, the server responds with a healthy http 200 response but returns no content in the response at all. In fact the raw response in it's unmodified entirety is: Code: HTTP/1.1 200 OK Content-Type: text/html Server: Microsoft-IIS/6.0 X-Powered-By: PHP/5.2.6 MicrosoftOfficeWebServer: 5.0_Pub X-Powered-By: ASP.NET Date: Fri, 28 Jun 2013 18:30:53 GMT Connection: close Questions / suggestions: Are all these 3 links to pages that are managed within the same WordPress installation / back end control panel? If so, are you able to notice anything in the WordPress control panel that differs WRT page configuration between the 2 working pages and 1 non-working page? Have you tried recycling your app pool in the DASP control panel? Have you tried deactivating / reactivating the WordPress theme? This could be a WordPress "white screen of death" scenario which can be caused by a number of different things. If this is the case, you might need to go looking for PHP processing exceptions to help localize the cause - I think DASP support need to be involved to dredge the details from the server logs if this is necessary.
Hi, I've pasted your questions in here so I can "try" to answer them. Are all these 3 links to pages that are managed within the same WordPress installation / back end control panel? I'm not sure what back end control panel means. But maybe this will help. The two working pages were uploaded with Backup Buddy. Which makes the whole WP installation easy... runs a script and changes all of the links that need to change to go to a new server. The one that does not work, would not upload that way so I decided to give uploading it myself a try. All three pages were built the same way, and all three run the same on my local host. It's just been since trying to move the employee schedule that all of this has come up. If so, are you able to notice anything in the WordPress control panel that differs WRT page configuration between the 2 working pages and 1 non-working page? I can't see anything. They were all built at the same time, have the same plugs ins, etc. Not sure what WRT is? Have you tried recycling your app pool in the DASP control panel? No, I'm not really sure what that is. I will go look that option. Have you tried deactivating / reactivating the WordPress theme? Yes, I just did and it still has a blank screen. I wonder if I should reload the entire site? I could just start over I suppose... even rebuild that page, but since it works on my localhost I'm not thinking it's the page. Thanks again... Sue
update to last message I recycled my app pool and still nothing shows up. When I'm in "manage my databases" the two working pages are using 1mb of their database allotment, and the blog that doesn't work is using 0mb. I wonder if I need to delete the emp. sched. database tables and try uploading the ones from my hard drive as it doesn't seem to be letting me overwrite them? And I guess if I was going to do a reinstall on all of it, it might be best to get rid of the emp. schedule database altogether and create a new one to re-upload to? On the subject of looking for PHP processing exceptions to help localize the cause.. this has been my first attempt ever at Wordpress/php and it seems a miracle in and of itself that I was able to manipulate the php files/template to look like the existing static site. So, I'm not so sure I'd be able to find a PHP processing exception... let alone the rule at this point. Thanks again.
The evidence suggests this is a broken WordPress installation / white screen of death but I'm afraid I don't know what went wrong during the sequence of events you followed that's caused it. Given this is working locally for you adds weight to the theory that there's been something broken or misconfigured at upload time either in the WP uploaded files or it's database. I'm sure this could be fixed as-is in place without taking the nuclear approach of starting again from scratch if there was enough debugging effort applied to it and input from DASP support to provide logged info about any PHP exceptions thrown. I'm really not able to advise with any confidence that deleting database tables / databases is the right thing to do here - that would be very bad advice from me when I can't see the internals. I think your options are: 1) Continue trying to fix this as-is in place 2) If you don't get any results with (1), seek help from someone who can get hands on with this problem so they can continue trying to fix this as-is in place 3) When all else fails, abort mission and take the nuclear option of flattening absolutely everything in your account, install a clean WordPress installation and build a new site from the ground up. I think that's all I have for you.
Thanks again CrystalCMS for the advice. I guess I could go back to dasp support, but they are the ones that sent me to the forum. It's odd, sometimes I get helpful people there and sometimes I don't. I find that somewhat frustrating. I have made an effort to hire someone locally to help/instruct me, and can't seem to get any takers. But I can always try that again. I think that if I get rid of everything, first I will need to figure out how to get rid of the WP installation. What happened was more than likely "user error", perhaps the sequence of events in the install was off somehow.
It works now! Hi Crystal CMS, I thought I would send an update to the "saga". I decided that prior to taking the nuclear option hat I would try to reinstall things one part at a time. So, on the FTP site I deleted the blog on the server, and then uploaded it again from my server. And now it works! I did have to go into the WP dashboard and upload the images and reset some of the plugins.. but it seems to be up and running! Thanks again for you patience.
