Simple Machines Community Forum

Archived Boards and Threads... => Archived Boards => SMF Feedback and Discussion => Topic started by: Justyne on August 09, 2003, 11:38:06 AM

Title: Question: Will there be a backup database feature
Post by: Justyne on August 09, 2003, 11:38:06 AM
Hello... does anyone know if there will be a backup database feature?
Title: Re:Question: Will there be a backup database feature
Post by: Jeff Lewis on August 09, 2003, 11:39:13 AM
You can currently get a dump of your database, not sure yet how much it will be expanded though.
Title: Re:Question: Will there be a backup database feature
Post by: Spaceman-Spiff on August 09, 2003, 11:44:22 AM
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
Title: Re:Question: Will there be a backup database feature
Post by: Justyne on August 10, 2003, 01:08:42 PM
*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* )
Title: Re:Question: Will there be a backup database feature
Post by: 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.
Title: Re:Question: Will there be a backup database feature
Post by: Parham on August 10, 2003, 01:21:12 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.
Title: Re:Question: Will there be a backup database feature
Post by: Justyne on August 10, 2003, 01:27:04 PM
yeah I now figured that out as well...
I was always scared of trying this button cause I thought it would delete everything.
Title: Re:Question: Will there be a backup database feature
Post by: Parham on August 10, 2003, 01:28:37 PM
Empty, Drop, and Dump were all buttons that freaked me out, LOL.
Title: Re:Question: Will there be a backup database feature
Post by: Justyne on August 10, 2003, 01:31:46 PM
I guess I will dump my page now... I have to move to another host. We are generating too much traffic somehow.
Title: Re:Question: Will there be a backup database feature
Post by: [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]
Title: Re:Question: Will there be a backup database feature
Post by: Justyne on August 10, 2003, 05:18:06 PM
Backup Database I like.. :))
that is something everyone understands :)
Title: Re:Question: Will there be a backup database feature
Post by: Parham on August 10, 2003, 05:38:51 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 ;)
Title: Re:Question: Will there be a backup database feature
Post by: [Unknown] on August 10, 2003, 05:55:06 PM
taking credit for my idea!!! LOL ;)

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

-[Unknown]
Title: Re:Question: Will there be a backup database feature
Post by: Ben_S on August 10, 2003, 05:57:20 PM
"Dump Windows"

Fantastic idea ;)
Title: Re:Question: Will there be a backup database feature
Post by: Justyne on August 10, 2003, 06:09:04 PM
dump windows the way I'd understand it??
Oooh gorgeous ;-)
Title: Re:Question: Will there be a backup database feature
Post by: dschwab9 on August 13, 2003, 07:35:17 AM
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
Title: Re:Question: Will there be a backup database feature
Post by: NV on August 14, 2003, 05:26:59 AM
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??
Title: Re:Question: Will there be a backup database feature
Post by: Compuart on August 14, 2003, 12:48:34 PM
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.