Hello... does anyone know if there will be a backup database feature?
You can currently get a dump of your database, not sure yet how much it will be expanded though.
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
*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* )
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.
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.
yeah I now figured that out as well...
I was always scared of trying this button cause I thought it would delete everything.
Empty, Drop, and Dump were all buttons that freaked me out, LOL.
I guess I will dump my page now... I have to move to another host. We are generating too much traffic somehow.
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]
Backup Database I like.. :))
that is something everyone understands :)
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 ;)
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]
dump windows the way I'd understand it??
Oooh gorgeous ;-)
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
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??
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.