Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Not a member yet? Click here to register.
Forgot Password?
  1. Home
  2. Discussion Forum
  3. PHPFusion 6 Support
  4. Official Core Support - 6
  5. To big size database backup problem

To big size database backup problem

Asked Modified Viewed 2,499 times
Back to Forum Index Previous Topic Next Topic
Print
N
Nepster
N
  • Junior Member, joined since
  • Contributed 31 posts on the community forums.
  • Started 4 threads in the forums
  • Started this discussions
asked
Junior Member

We have big forum there we need backup's by diferent tables, a problem is what: table _posts is too big to backup even it compresed, delete threats is damage to us we need save big part.. so any suggest how to backup?
0 replies

7 posts

W
WEC
W
WEC 10
  • Veteran Member, joined since
  • Contributed 946 posts on the community forums.
  • Started 5 threads in the forums
answered
Veteran Member

MySQL Administrator if your host supports it:

http://www.mysql.com/products/tools/a...nistrator/
0 replies
N
Nepster
N
  • Junior Member, joined since
  • Contributed 31 posts on the community forums.
  • Started 4 threads in the forums
  • Started this discussions
answered
Junior Member

i need to do backups from site..
0 replies
W
WEC
W
WEC 10
  • Veteran Member, joined since
  • Contributed 946 posts on the community forums.
  • Started 5 threads in the forums
answered
Veteran Member

MySQL Administrator will do that if your host supports it.
0 replies
N
Nepster
N
  • Junior Member, joined since
  • Contributed 31 posts on the community forums.
  • Started 4 threads in the forums
  • Started this discussions
answered
Junior Member

we are clients of host, and no ways to phpmyadmin, need backups only from site administration.
0 replies
W
WEC
W
WEC 10
  • Veteran Member, joined since
  • Contributed 946 posts on the community forums.
  • Started 5 threads in the forums
answered
Veteran Member

MySQL Administrator will work for clients if your host supports it.

Try to install it and give the login information and see if connection succeds.
0 replies
N
Nepster
N
  • Junior Member, joined since
  • Contributed 31 posts on the community forums.
  • Started 4 threads in the forums
  • Started this discussions
answered
Junior Member

i tryed MySQL Administrator... could not connect.. maybe host didn't support
heh...how to do no limit to table to backup...
Edited by Nepster on 05-12-2006 21:36,
0 replies
W
WEC
W
WEC 10
  • Veteran Member, joined since
  • Contributed 946 posts on the community forums.
  • Started 5 threads in the forums
answered
Veteran Member

You can export a single table by dumping a limited number of rows only in phpMyadmin.

Defaukt setting is that phpMyadmin suggests you to dump all rows starting at record #0.

You can reduce the number of row and download the database table in chuks.

Lets say that phpMyadmin says that your table has 40456 rows, then set:

Dump 5000 row(s) starting at record # 0

Increase untill you find limit on what your server accepts.

Then dump next chunk:

Dump 5000 row(s) starting at record # 5001

Continue this way till you have the entire table downloaded.
0 replies

Category Forum

Official Core Support - 6

Labels

None yet

Statistics

  • Views 0 views
  • Posts 7 posts
  • Votes 0 votes
  • Topic users 2 members

0 participants

Notifications

Track thread

You are not receiving notifications from this thread.

Related Questions

Not yet