copy of one esvon database to another

I have two copies of Esvon Classifieds.
I would like to upload the database from one to the other
I don't know MySql commands
any simple way?
How do you restore a backup database?
Maybe I could restore a backup of one database to another

by the way the database is over 5mb

I know, it will the subject of today's manual update!

Stand-by...

Cheers
Charles

Leer,

If you have shell access it's really easy. .

1. Create the backup: mysqldump -u USER -p DBNAME -Q > cl_dump.sql

2. create the new Db using the cpanel MySQL tool.

3. Load the data: mysql -u USER -p DBNAME < cl_dump.sql


If you don't have access to SSH use cpanel:

1. Select the backup/download of the MySQL Db .

2. Create the new Db.

3. Select the Restore Db option and choose the filename of the Db you backup/downloaded.

-jay

 

I typed :

mysqldump -u USER -p DBNAME -Q > cl_dump.sql
with user being the user name to login to the database
and the DBName is the Databases name and I get an error

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near

I don't know the first thing about Executing a SQL command

Try it without the -Q option.

NO LUCK

on the BACKUP page of ESVON they have this:

mysql -u root -p databasename < output_saved_as.sql to reload backup

I know what databasename is put what is root?

can I somehow use the backup file of the one db to install the information on the new db?

Charles,

How does the manual approach taking one database from one copy of ESVON to another?

What type of server do you have?

How do I find out what kind of server I have?