database exporter

[pmbguy]

ok, dunno if anyone has coded anything similar to this yet, but if they have which i'm sure someone must have, here's another share...

ok, i often spend long amounts of time either capped, ie: unable to access my server from my pc, or away from home, so i thought it would be pretty neat having a portable database backup tool... and preferably one i don't need to login to cpanels or funny stuff but could access using my owners tools or stash in some innocent looking file or unlinked action kinda thing...

took me a while to get it to work out so the database export could be imported and a few litres of coffee, but NOW, as i prepare my next cuppa I'm happy to bring you this...

The function isn't entirely my work, but i took the liberty to name it anyways, lol...

[pmbguy]

comments and feedback welcome...

thanks too if this deserves it, lol...

[CreativityKills]

dnt undastand u

[shakil420]

NOT WORKING @ my localhost [wamp]

create("$filedname", PCLZIP_OPT_REMOVE_PATH, "$folder", PCLZIP_OPT_ADD_PATH, 'backup'); if ($v_list == 0) { die("Error : ".$archive->errorInfo(true)); } echo "Database Backed Up
Download Zipped File
Click Here 

click here herf == http://127.0.0.1/kekz1/wap/%5C%22%5C%22 ?????? /// simple its not work

----------------------
1. whats the problem ?
2.is it not works on wamp ?
---------------------
@ pmbguy

[pmbguy]

i got no idea why it doesn't work on wamp...

I canb tell you it does work... i've exported my database a few times... even managed to download trhe exported copy with opera, which had gioven me a few problems previously...

I'll set up a demo, give me a few minutes...

Added after 12 minutes:

ok, well as for the wamp error, i got no idea... wamp always gives problems... Like i got a few things that never work on wamp but work great on server...

ok, you think i was lying i'm guessing, so here's proof,

http://wapwarrior.co.cc/db_test

if you're hoping for some juicy database stuff, I'm sorry i uploaded a blank database there... but try the url and you'll see my script in action...

Added after 13 minutes:

ok, i updated it to make it a bit more self sufficient, ie: stand alone cause i copied the db info from core n config.php...

anyways, here you go... maybe this will work with wamp...
(if it still doesn't, try the demo link i put up...)

[pmbguy]

ok, i've done an update to the script that's updated on the demo now. I'll upload the updated script here in a few minutes one i get back to my pc...

Added after 36 minutes:

ok, script v2... demo has been updated too btw...

[ayoomo9]

Nice idea, though i've not yet test it on my server.

[pmbguy]

cool cool, well hope it works out, keep me posted on how it goes...

[pmbguy]

ok, i've done a bit more updating... now you can send backed up via email...

still gotta try make the code a bit more tidy before i post it up here though

Added after 2 minutes:

one question though, does anyone here have an email attachment function that works, i been trying different examples for hours... in the end i resorted to using someones script cause it didn't need attachments to be uploaded, but it's driving me nuts, lol

[pmbguy]

ok, after doing a minor update, you can now email database to yourself too...

I've been asked how it works, so here goes:

the line with my coders notice changes...

echo "Database Backed Up<br/>Download Zipped File<br/><a href=\"$randname\">Click Here</a><br/><br/>Send Via Email<br/><a href=\"sendfile.php?fileurl=".$file2url."\">Click 2 Email</a><hr/>(c)oded by pmbguy 2010"; //please leave coders notice if you add it to tools, etc...

and you add sendfile.php to the directory and add a variable there to carry the $fileurl to the send url box...

sendfile.php is available with instructions from authors page:
PHP Send File By Email

hope this helps

[Mysterio]

I tested on Wamp and Xamp and it works (latest version).

One thing that does't work is, when getting some values which may have ' sign or " sign. The code becomes unreadable when trying to import that database later.

[pmbguy]

well, my ' " etc get changed to html symbol codes before getting posted to database, that should solve the problem...

[Mysterio]

well, my ' " etc get changed to html symbol codes before getting posted to database, that should solve the problem...

Hmmm... Well, you inspired me for my CMS (in developing progress) to make and one-click db backup and restore.

By the way, I have hundred INSERT queries in my code and I POST/GET/REQUEST thousand values. How to change them all (some code which handles all values) and be treated as html symbols?

[rockman]

when im downloading the backup its always 144b and zero database bytes. How to fix that? Thanks