Re: [cobalt-users] mysql database

["John Poynton" <support@xxxxxxxxxxx>]

You COULD use phpMyAdmin's dump feature to obtain a 'Structure and data'
dump from your current MySQL database, then use phpMyAdmin's 'Run SQL query'
window (cut & paste) to recreate the tables on your NEW MySQL server -
however it is a slow process.

Far more efficient is to use 'mysqldump' as suggested a few posts above ...
% mysqldump -h myhost -u root -pmypass dbname > dbname_backup.sql

ftp that file to your cobalt server.

Then telnet to your cobalt server and use ...
% mysqladmin -u root -pmypass create dbname
to create the database and
% mysql -u root -pmypass dbname < dbname_backup.sql
to populate database with tables and data ...

John Poynton




> our cobalt server are from a remote dedicated web server that we acquired
> from catalog.com.
> im just a novice, and the only way i think the solution is to re-create
all
> the tables to our cobalt server.
> i have a phpmyadmin installed on our server.
>
> thanks nell.