WampServer

Is there anyone with some quick advice about how to copy a database under the following conditions (ps the search isnt working atm)

-I have acces to phpymadmin and have created a .sql file with create procedures of the entire database (5 mb)
-I changed the maxfilesize to 20M
-I want to import the sql file but the new database has to be called ogame1 instead of the old a7etc_ogame2.

When I go to the database ogame1, who has ogame1 as user, as root and then press import the file imports BUT it creates its own database and the data does not go into the ogame1.

I would like all data to go to ogame 1 but at the same time the tables will have to be created.]

Thanks in advance!

What type of db do you have?

Have fun,

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

MySQL client version: 4.1.22
Used PHP extensions: mysql

I tried exporting without the "create" checker and the create the tables by using the default create script that is part of the application. The application then works.

Then login as ogame1 and then press import using the exported data without create function.

But I got a cannot display page after 5 minutes of importing. Think it won't work. Will try again.

The DB is quite big, about 5 MB and 45000 entries, but succesfull when it creates its own database.



Edited 2 time(s). Last edit at 01/25/2008 09:45PM by sdk.

When I mentioned db type, I meant these:

DB Type Description
MyISAM Default engine as of MySQL 3.23 with great performance
MEMORY Hash based, stored in memory, useful for temporary tables
InnoDB Supports transactions, row-level locking, and foreign keys
BerkeleyDB Supports transactions and page-level locking
BLACKHOLE /dev/null storage engine (anything you write to it disappears)
EXAMPLE Example storage engine
ARCHIVE Archive storage engine
CSV CSV storage engine
ndbcluster Clustered, fault-tolerant, memory-based tables
FEDERATED Federated MySQL storage engine
MRG_MYISAM Collection of identical MyISAM tables
ISAM Obsolete storage engine

And 2 famous ones are MyISAM and InnoDB. With MyISAM, you can simply rename the folder, but not w/ the other

If you're not sure how to do it, just google for mysqldump, download and use it

Have fun,

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



Edited 1 time(s). Last edit at 01/25/2008 11:13PM by yfastud.

The tables all show type=MyISAM

In that case, go to C:\wamp\bin\mysql\mysql5.0.45\data folder and rename the of the db that you wish to

Have fun,

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