Hi dave
I use my servers own software for dbases
called mpanel.
Org db = threads1
New db = Threads2
-------------------------------------
1. I made a new db threads2
-------------------------------------
2. Exported (dumped I believe) threads1 db to my own hard drive from within my servers mpanel as the one from the admin does not work.
--------------------------------------
3. Logged in to my new db threads2 mpanel.
---------------------------------------
4. Imported threads1 db sql file from my hard drive (using mpanel) which was called "threads1backup.sql" as follows..
=========================================================
Mpanel page reads .........
In order to import data into this database you must click on the "Browse..." button and select a previously dumped file. These files are just a long list of SQL commands which reconstruct any aspect of the database dumped.
Import file: ............Click browse.
==========================================================
It then askes for the name of the file to import from my hard drive so I click the orginal exported threads1 db sql file "threads1backup.sql".
It started to import and went on until the file looked like it had uploaded (the progress bar on status bas was full) then I received this..........
Fatal error - Maximum execution time of 30 seconds exceeded in ..address of mysql control panel via isp - not threads.
Checked threads2 db but nothing there.
Now stuck...So have I did something wrong??
---------------------------------------------
If I get passed here sometime then...............
5. Where do I do the below from? - within the admin page msql command?
mysqldump --quick --add-drop-table --add-locks --lock-tables -ufoo_user -p foo1_db >foo1_db.sql
mysql -ufoo_user -p foo2_db < foo1_db.sql
-----------------------------------------------
6. (Your No.2) Copy all files from the source directories to the target directories.
Can I just copy all files to my hard drive then back to the new dir on web site.
That will do for now or I will get MORE
Thanks for your help, any more help with this that you can give will be helpful to me and I suppose others as well.
