WampServer

Installed today, I tried to import a zip file of my live DB. I get the message "file size exceeded the maximum size permitted by your PHP configuration." I don't know anything about PHP or SQL.

Is the a simple step by step guide? I use Windows 7
Regards

Drachsi

Dont use phpMyAdmin if you are importing a large database.

Use the mysql console ... wampmanager -> MySQL -> MySQL Console

Its a command line execution of the mysql.exe ( if you have not set a password for the 'root' user yet just hit enter when it asks for a password, otherwise use the password you set )

at the mysql prompt, do this

mysql> source c:\folder\that\holds\your\backup.sql


I cant remember is it like windows '\' or unix '/' as folder seperators, if one fails try the other.

Hi, that seemed ok, but how do I get it into one of four DB's on my server?

Regards

Drachsi

before you do the source command do this

use databasename;

to select the database for it to be imported into

Hi, That worked fine. Many thanks

Regards

Drachsi

Back again. The DB installed correctly, but as it is now on Wamp I cannot login to WP. I changed the wp_config.php file data, but still would not let me log into WP. Any suggestions? I guess there is a file in the DB that also needs changing?

Regards

Drachsi

Look in the user table there are at leaset 2 references to the site name used when it was originally installed ( on the live server ) these need changing to the name you used whne yo installed WP on your localhost

Hi,

I looked in the wp_user table and there is no mention of the old site name, the user_url is empty. I checked on a plain WP DB and that is also empty. You are talking about the DB I imported?

Regards

Drachsi

its the wp_options table


line 3 and line 21 if i remember?

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Hi, yes that worked, only 1 reference. I had to use the password from the live server, can I change this on my localhost.

Appreciate all the help and understanding.

Regards
Drachsi

No there is two references.

Keep looking!

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

He is my wp_options table. I can only see one.

Edit Edit Copy Copy Delete Delete 1 siteurl [localhost] yes
Edit Edit Copy Copy Delete Delete 2 blogname Demo yes
Edit Edit Copy Copy Delete Delete 3 blogdescription Just another WordPress site yes
Edit Edit Copy Copy Delete Delete 4 users_can_register 0 yes
Edit Edit Copy Copy Delete Delete 5 admin_email me@another.com yes
Edit Edit Copy Copy Delete Delete 6 start_of_week 1 yes
Edit Edit Copy Copy Delete Delete 7 use_balanceTags 0 yes
Edit Edit Copy Copy Delete Delete 8 use_smilies 1 yes
Edit Edit Copy Copy Delete Delete 9 require_name_email 1 yes
Edit Edit Copy Copy Delete Delete 10 comments_notify 1 yes
Edit Edit Copy Copy Delete Delete 11 posts_per_rss 10 yes
Edit Edit Copy Copy Delete Delete 12 rss_use_excerpt 0 yes
Edit Edit Copy Copy Delete Delete 13 mailserver_url mail.example.com yes
Edit Edit Copy Copy Delete Delete 14 mailserver_login login@example.com yes
Edit Edit Copy Copy Delete Delete 15 mailserver_pass password yes
Edit Edit Copy Copy Delete Delete 16 mailserver_port 110 yes
Edit Edit Copy Copy Delete Delete 17 default_category 1 yes
Edit Edit Copy Copy Delete Delete 18 default_comment_status open yes
Edit Edit Copy Copy Delete Delete 19 default_ping_status open yes
Edit Edit Copy Copy Delete Delete 20 default_pingback_flag 0 yes
Edit Edit Copy Copy Delete Delete 21 default_post_edit_rows 20 yes
Edit Edit Copy Copy Delete Delete 22 posts_per_page 10 yes
Edit Edit Copy Copy Delete Delete 23 date_format F j, Y yes
Edit Edit Copy Copy Delete Delete 24 time_format g:i a yes
Edit Edit Copy Copy Delete Delete 25 links_updated_date_format F j, Y g:i a yes
Edit Edit Copy Copy Delete Delete 26 links_recently_updated_prepend <em> yes
Edit Edit Copy Copy Delete Delete 27 links_recently_updated_append </em> yes
Edit Edit Copy Copy Delete Delete 28 links_recently_updated_time 120 yes
Edit Edit Copy Copy Delete Delete 29 comment_moderation 0 yes
Edit Edit Copy Copy Delete Delete 30 moderation_notify 1 yes

Regards
Drachsi

There is multiple pages in that table

That's just the first 30 lines

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Hi, Sorry, told you I was a newbie. That worked, many thanks for your support. All I have now to solve is in "permalink" is how to show page names and not /?p=703 etc.

Regards
Drachsi