[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 4505: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3706)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 4507: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3706)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 4508: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3706)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 4509: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3706)
Liway Forums • View topic - How to backup MySQL db using php?

How to backup MySQL db using php?

Discussion & Help on SQL and in matters relating to DBMSs such as MySQL and PostgreSQL.

How to backup MySQL db using php?

by anggit » Sat Mar 05, 2011 5:02 am

Anyone have coolest tips/tricks to backup mysql db using php? Please post it here. Thanks ;)
anggit
Junior Member
 
Posts: 55
Joined: Tue May 18, 2010 8:26 am

Re: How to backup MySQL db using php?

by Max » Sun Mar 06, 2011 12:59 pm

What do you mean by that? What do you want the end result to be?
Max
Administrator
 
Posts: 1045
Joined: Sat Jul 18, 2009 3:17 pm

Re: How to backup MySQL db using php?

by anggit » Tue Mar 08, 2011 7:44 am

Like generate .sql or else that can be restored in server. Backup without phpmyadmin & cpanel but with your own php.
anggit
Junior Member
 
Posts: 55
Joined: Tue May 18, 2010 8:26 am

Re: How to backup MySQL db using php?

by Max » Tue Mar 08, 2011 7:51 am

Why can't you use cPanel or phpmyadmin?
Max
Administrator
 
Posts: 1045
Joined: Sat Jul 18, 2009 3:17 pm

Re: How to backup MySQL db using php?

by anggit » Tue Mar 08, 2011 9:17 am

Can download directly without login first. So can sent them to gmail as backup, etc.
anggit
Junior Member
 
Posts: 55
Joined: Tue May 18, 2010 8:26 am

Re: How to backup MySQL db using php?

by Max » Tue Mar 08, 2011 9:22 am

gmail doesn't support large attachments anyway, it's probably not the best way to do it. But it is possible - phpmyadmin does it after all, so you may consider checking out it's source code.
Max
Administrator
 
Posts: 1045
Joined: Sat Jul 18, 2009 3:17 pm

Re: How to backup MySQL db using php?

by anggit » Tue Mar 08, 2011 9:40 am

Yes that's just ex. Mr Max. I do not really understand what the language used on phpmyadmin and where is exactly source code located. So i ask here if there's someone have kinda source code like that. Btw where your timezone. Good evening :D
Last edited by anggit on Tue Mar 08, 2011 9:55 am, edited 1 time in total.
anggit
Junior Member
 
Posts: 55
Joined: Tue May 18, 2010 8:26 am

Re: How to backup MySQL db using php?

by Max » Tue Mar 08, 2011 9:54 am

As implied my it's name, it is PHP.

http://www.phpmyadmin.net/home_page/downloads.php
Max
Administrator
 
Posts: 1045
Joined: Sat Jul 18, 2009 3:17 pm

Re: How to backup MySQL db using php?

by anggit » Tue Mar 08, 2011 10:11 am

Thx. I just found a little phpmyadmin, maybe it's easier http://phpminiadmin.sourceforge.net/ :d
anggit
Junior Member
 
Posts: 55
Joined: Tue May 18, 2010 8:26 am

Re: How to backup MySQL db using php?

by anggit » Sun Mar 20, 2011 4:00 pm

anggit
Junior Member
 
Posts: 55
Joined: Tue May 18, 2010 8:26 am

Re: How to backup MySQL db using php?

by anggit » Sat Jun 18, 2011 11:42 pm

Note: this is only php example. Cannot export high rows. Depend on memory_limit
anggit
Junior Member
 
Posts: 55
Joined: Tue May 18, 2010 8:26 am

Re: How to backup MySQL db using php?

by Max » Sun Jun 19, 2011 12:53 am

Max
Administrator
 
Posts: 1045
Joined: Sat Jul 18, 2009 3:17 pm

Re: How to backup MySQL db using php?

by anggit » Sun Jun 26, 2011 11:16 pm

Yes, but we can protect by specifying the IPs who can downloading.
anggit
Junior Member
 
Posts: 55
Joined: Tue May 18, 2010 8:26 am

Re: How to backup MySQL db using php?

by Max » Mon Jun 27, 2011 10:45 am

I still think it's better to only back up form cPanel. Backing up is not a simple process, especially with larger sites, that's why there are special processes for doing this - ie. because it can take up a considerable amount of resources, and is a potential security risk if someone ill-intentioned manages to get a backup of your site without your permission.
Max
Administrator
 
Posts: 1045
Joined: Sat Jul 18, 2009 3:17 pm


Return to Database Development



Who is online

Users browsing this forum: No registered users and 1 guest

cron
Not able to open ./cache/data_global.php