Posted by Captain Paralytic on 11/23/07 10:30

On 22 Nov, 19:31, "Flemming" <flemm...@mail.dk> wrote:
> Hi there,
>
> I have a small database running in mySQL on a web-hotel. I use PHP to access
> the database.
>
> Unfortunately, the web-hotel does not offer any possibilities for backing up
> databases/tables, other than copying the tables manually one by one using
> the facilities of phpMyAdmin.
>
> What I would ideally like to have is a PHP routine that that makes an exact
> copy of a specified table. I could then easily use that to createl copies of
> all the relevant tables in the database.
>
> I thought this would be a relatively easy task, but this does not appear to
> be the case. Or maybe I am blind. I can see in phpMyAdmin the SQL statements
> needed to create a new empty table and copy the content from the original
> table. I could of course copy this code into PHP, but what then if I change
> a table? Then I need to change this code as well.
>
> Is there a smarter way?
>
> Flemming

phpmyadmin has an export tab in the database view. This will export
all the tables, complete with instructions to create the relevant
indexes

[Back to original message]