Question: Will there be a backup database feature

Started by Justyne, August 09, 2003, 11:38:06 AM

Previous topic - Next topic

Justyne

Hello... does anyone know if there will be a backup database feature?
Ever tried. Ever failed. No matter. Try Again. Fail again. Fail better.

Jeff Lewis

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

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* )
Ever tried. Ever failed. No matter. Try Again. Fail again. Fail better.

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.
Ever tried. Ever failed. No matter. Try Again. Fail again. Fail better.

Parham

Quote from: Justyne on August 10, 2003, 01:09:59 PM
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.
Ever tried. Ever failed. No matter. Try Again. Fail again. Fail better.

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.
Ever tried. Ever failed. No matter. Try Again. Fail again. Fail better.

[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 :)
Ever tried. Ever failed. No matter. Try Again. Fail again. Fail better.

Parham

Quote from: [Unknown] on August 10, 2003, 05:14:16 PM
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]

Quote from: Parham on August 10, 2003, 05:38:51 PM
taking credit for my idea!!! LOL ;)

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

-[Unknown]

Ben_S

Liverpool FC Forum with 14 million+ posts.

Justyne

dump windows the way I'd understand it??
Oooh gorgeous ;-)
Ever tried. Ever failed. No matter. Try Again. Fail again. Fail better.

dschwab9

Quote from: [Unknown] on August 10, 2003, 05:14:16 PM
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   ;D

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:

Quote<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.
Hendrik Jan Visser
Former Lead Developer & Co-founder www.simplemachines.org
Personal Signature:
Realitynet.nl -> ExpeditieRobinson.net / PekingExpress.org / WieIsDeMol.Com

Advertisement: