WampServer

I still cannot do this. Once the database is created, I close out of WAMP, copy the entire folder from here:

C:\wamp\bin\mysql\mysql5.0.45\data

To that same location on another PC with WAMP. I then start WAMP on the new PC and open the mysql console.

I can select the database and use show tables. I can see all of the tables. However, when I go to run a query, like

SELECT * FROM users;

I get an error message. Am I missing a step or something? It is getting really annoying to re-create the databases every time I switch PCs. Thanks.

I have found that the cleanest way to do this is to export source and imported at the target server. That said, what is the error you are getting? I mean, I get an error does not offer much to base any assistance on


Regards

Quote

I still cannot do this. Once the database is created, I close out of WAMP, copy the entire folder from here:

C:\wamp\bin\mysql\mysql5.0.45\data

You can only copy folder if storage type is MyISAM, and after copy, you still have to setup user(s) w/ needed privilege(s) to access those db. I copy db all the time w/o any problem ;-)

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

How do you export/import source?

How do you make it MyISAM storage?

I can't tell you the error until later tonight when I go home and test it on my PC... at work now. Thanks.

To export:

1) Click on WAMP systray icon
2) Choose phpMyAdmin
3) Select database off drop-down list
4) Click database name on left hand pane
5) Click export tab
6) Scroll down and click Go

Normally, this comes up set to SQL by default, but just in if in case, before you click GO

7) Copy the query code generated

All that remain is to run this query at target computer; so, find a way to get this text there

8) Once you have copied text/query in new computer
8a) Open phpMyAdmin
8b) Make sure you have the database in new computer. If not there, create it
8c) Click on the database
8d) Click on import
8e) Select SQL and click GO
8f) Follow prompts ...


You could also select the database, click SQL Query, paste the SQL Code and watch it create all the tables


NOTE: Do not attempt the latter if you have large files ....

Hope this helps!

thanks southbeach. it worked. at first i forgot to create db in new pc but finally i got that.