Topic: Question: Will there be a backup database feature

[Justyne]

Hello... does anyone know if there will be a backup database feature?

[Jeff Lewis]

You can currently get a dump of your database, not sure yet how much it will be expanded though.

[Spaceman-Spiff]

i think it will be good to install phpMyAdmin, if you don't have one already (check your site CP)
it's a very useful db tool

[Justyne]

*lol* I always though dump was something like delete....

thanks for enlightning me!

(cause normally if you say... I dumped my boyfriend that pretty much means you got rid of him. Looks like I really misunderstood something there *LOL* )

[Justyne]

Thank I have phpMyAdmin... I just figures out how to use it. *LOL* It is just that this is my first week with Yabb and it is a lot of stuff to learn. I guess I annoy everyone here by asking obvious questions.

[Parham]

Thank I have phpMyAdmin... I just figures out how to use it. *LOL* It is just that this is my first week with Yabb and it is a lot of stuff to learn. I guess I annoy everyone here by asking obvious questions.

LOL, nah it's not one bit annoying because we all went through stuff like that.  Think of dump in this way:  You're dumping a copy of your database into a file for backup.

[Justyne]

yeah I now figured that out as well...
I was always scared of trying this button cause I thought it would delete everything.

[Parham]

Empty, Drop, and Dump were all buttons that freaked me out, LOL.

[Justyne]

I guess I will dump my page now... I have to move to another host. We are generating too much traffic somehow.

[[Unknown]]

This brings up a very good point.  WHY in the CRAP should we keep it dump?  If I saw that in Windows:

"Dump Windows"

I would freak out and get scared of that stupid button.

We should rename it to something like...

"Download database" or "Get a copy of the database" or "Backup database".

-[Unknown]

[Justyne]

Backup Database I like.. )
that is something everyone understands

[Parham]

This brings up a very good point.  WHY in the CRAP should we keep it dump?  If I saw that in Windows:

"Dump Windows"

I would freak out and get scared of that stupid button.

We should rename it to something like...

"Download database" or "Get a copy of the database" or "Backup database".

-[Unknown]

taking credit for my idea!!! LOL

[[Unknown]]

taking credit for my idea!!! LOL

Eh?  Did you say this?  If so - all props to you, let's do it.

-[Unknown]

[Ben_S]

"Dump Windows"

Fantastic idea

[Justyne]

dump windows the way I'd understand it??
Oooh gorgeous ;-)

[dschwab9]

If I saw that in Windows:

"Dump Windows"

I would freak out and get scared of that stupid button.

I think pushing it would be a great idea   

[NV]

Hi,

another backup related question

I have a 90Mb forum database and the messages table take up most space, naturally.

When i started the board I used the mysqldump command , but as my database grew I had to 'pipe' it right into a gz-file otherwise I would conflict with settings from the provider.

Now my database has become so large that even this 'piping' trick no longer seems to work.

So I had a look at the lastest edition of PhpMyAdmin that allows you to export your database.
This also resulted in some problems:

- i edited the IIS-setting (working from W2K environment) concerning cgi timeout problems and
- i have edited the php.ini file concerning the timeout settings.

Now i'm faced with another problem: after 8Mb of exporting through PhpMyAdmin it stops and the last line of the created file says:

<b>Fatal error</b>:  Maximum execution time of 300 seconds exceeded in <b>d:\inetpub\wwwroot\phpMyAdmin2\libraries\mysql_wrappers.lib.php</b> on line <b>124</b><br />

php.ini looks like this:
max_execution_time = 300000
max_input_time = 240
memory_limit = 400M

Anyone any ideas??

[Compuart]

Large databases are indeed a pain to backup. For my own databases I made a tool that splits up the dump into chunks based on an execution time threshold. I might be able to convert it to the SMF [/s]dump[/s]backup database function.