Backup database

Monde en
1

But what can we do to fix it? It is important to have back up of the database for at least each week.

Any idea?

Kamran

----- Original Message ----
From: L’oiseau2nuit (ex- Zzz.) loiseau2nuit@no-log.org
To: kamran Mir Hazar editora@kabulpress.org
Cc: spip-en@rezo.net
Sent: Monday, April 28, 2008 7:11:08 PM
Subject: Re: [Spip-en] Backup database

I have the same problem. I think that most of the time it is due to the
spip_syndic table which cast every bit of limk published and the websites
you link to.

For me this was 5 years of backlinking on heavy traffic websites, so…

And by the way, I’m not a specialist but I think 14MB is much too bog for
a dump file.

Good luck.

Etienne B.
(It’s been long since last time I posted, 'Hope everything’s ok for
everyone…)

On Mon, April 28, 2008 6:28 pm, kamran Mir Hazar wrote:

Dear all,
I have faced an issue regarding backup the database. When I wanted to save
the database it is going so slow and I cannot load the page. The hosting
company says it is because of large files of dump. But I don?t think the
compressed backup would be more than 14MB.
I cannot backup the database via sPIP Cpanel. I’m using SPIP 1.0.2d
11132 and the latet version of MYSQL.
Any help?
Regards
Kamran_______________________________________________
spip-en@rezo.net - http://listes.rezo.net/mailman/listinfo/spip-en

spip-en@rezo.net - http://listes.rezo.net/mailman/listinfo/spip-en

2

if you can't get it through SPIP backup page, maybe by using mysql directly to do a dump. (from the command line with mysqldump, or mysql myadmin if it's installed on ur server)

Pierre

kamran Mir Hazar wrote:

But what can we do to fix it? It is important to have back up of the database for at least each week.

Any idea?

Kamran

----- Original Message ----
From: L'oiseau2nuit (ex- Zzz.) <loiseau2nuit@no-log.org>
To: kamran Mir Hazar <editora@kabulpress.org>
Cc: spip-en@rezo.net
Sent: Monday, April 28, 2008 7:11:08 PM
Subject: Re: [Spip-en] Backup database

I have the same problem. I think that most of the time it is due to the
spip_syndic table which cast every bit of limk published and the websites
you link to.

For me this was 5 years of backlinking on heavy traffic websites, so....

And by the way, I'm not a specialist but I think 14MB is much too bog for
a dump file.

Good luck.

Etienne B.
(It's been long since last time I posted, 'Hope everything's ok for
everyone...)

On Mon, April 28, 2008 6:28 pm, kamran Mir Hazar wrote:
> Dear all,
> I have faced an issue regarding backup the database. When I wanted to save
> the database it is going so slow and I cannot load the page. The hosting
> company says it is because of large files of dump. But I don?t think the
> compressed backup would be more than 14MB.
> I cannot backup the database via sPIP Cpanel. I'm using SPIP 1.0.2d
> 11132 and the latet version of MYSQL.
> Any help?
> Regards
> Kamran_______________________________________________
> spip-en@rezo.net <mailto:spip-en@rezo.net> - http://listes.rezo.net/mailman/listinfo/spip-en
>

_______________________________________________
spip-en@rezo.net <mailto:spip-en@rezo.net> - http://listes.rezo.net/mailman/listinfo/spip-en

3

Hi,

On Mon, Apr 28, 2008 at 7:23 PM, kamran Mir Hazar
<kamran_mirhazar@yahoo.com> wrote:

But what can we do to fix it? It is important to have back up of the
database for at least each week.

You can find the biggest tables with a mysql admin panel (like phpMyAdmin)
Maybe some tables are too much important but can be flushed :
spip_caches for example : flushing the cache (i the Admin panel)
before dumping can limits the dump filesize.

If you don't use the search functionality, you can disable the
indexation (this flushes the tables spip_index and spip_index_dico)
It's the same if you use a third-party tool for the statistics : think
to disable this functionality in SPIP : it will flush the tables
spip_visites and spip_visites_articles

Finally, try to disable the compression option : maybe it's this phase
that puts a limit to the initial file size.

With such tips, does it work now ?

.Gilles

Any idea?
Kamran

----- Original Message ----
From: L'oiseau2nuit (ex- Zzz.) <loiseau2nuit@no-log.org>
To: kamran Mir Hazar <editora@kabulpress.org>
Cc: spip-en@rezo.net
Sent: Monday, April 28, 2008 7:11:08 PM
Subject: Re: [Spip-en] Backup database

I have the same problem. I think that most of the time it is due to the
spip_syndic table which cast every bit of limk published and the websites
you link to.

For me this was 5 years of backlinking on heavy traffic websites, so....

And by the way, I'm not a specialist but I think 14MB is much too bog for
a dump file.

Good luck.

Etienne B.
(It's been long since last time I posted, 'Hope everything's ok for
everyone...)

On Mon, April 28, 2008 6:28 pm, kamran Mir Hazar wrote:
> Dear all,
> I have faced an issue regarding backup the database. When I wanted to save
> the database it is going so slow and I cannot load the page. The hosting
> company says it is because of large files of dump. But I don?t think the
> compressed backup would be more than 14MB.
> I cannot backup the database via sPIP Cpanel. I'm using SPIP 1.0.2d
> 11132 and the latet version of MYSQL.
> Any help?
> Regards
> Kamran_______________________________________________
> spip-en@rezo.net - http://listes.rezo.net/mailman/listinfo/spip-en
>

_______________________________________________
spip-en@rezo.net - http://listes.rezo.net/mailman/listinfo/spip-en

_______________________________________________
spip-en@rezo.net - http://listes.rezo.net/mailman/listinfo/spip-en

4

Hi

I don't think SPIP includes spip_cache or the visits in it's dump. Having said that, I am not sure anymore, I have a site with around 15000 articles, loads of authors and sections etc... last month the size of the compressed dump was around 35 Mb this month (about 100 more articles later) it jumped to 69Mb. So go and figure out.

George

Quoting Gilles Vincent <gilles.vincent@gmail.com>:

Hi,

On Mon, Apr 28, 2008 at 7:23 PM, kamran Mir Hazar
<kamran_mirhazar@yahoo.com> wrote:

But what can we do to fix it? It is important to have back up of the
database for at least each week.

You can find the biggest tables with a mysql admin panel (like phpMyAdmin)
Maybe some tables are too much important but can be flushed :
spip_caches for example : flushing the cache (i the Admin panel)
before dumping can limits the dump filesize.

If you don't use the search functionality, you can disable the
indexation (this flushes the tables spip_index and spip_index_dico)
It's the same if you use a third-party tool for the statistics : think
to disable this functionality in SPIP : it will flush the tables
spip_visites and spip_visites_articles

Finally, try to disable the compression option : maybe it's this phase
that puts a limit to the initial file size.

With such tips, does it work now ?

.Gilles

Any idea?
Kamran

----- Original Message ----
From: L'oiseau2nuit (ex- Zzz.) <loiseau2nuit@no-log.org>
To: kamran Mir Hazar <editora@kabulpress.org>
Cc: spip-en@rezo.net
Sent: Monday, April 28, 2008 7:11:08 PM
Subject: Re: [Spip-en] Backup database

I have the same problem. I think that most of the time it is due to the
spip_syndic table which cast every bit of limk published and the websites
you link to.

For me this was 5 years of backlinking on heavy traffic websites, so....

And by the way, I'm not a specialist but I think 14MB is much too bog for
a dump file.

Good luck.

On Mon, April 28, 2008 6:28 pm, kamran Mir Hazar wrote:
> Dear all,
> I have faced an issue regarding backup the database. When I wanted to save
> the database it is going so slow and I cannot load the page. The hosting
> company says it is because of large files of dump. But I don?t think the
> compressed backup would be more than 14MB.
> I cannot backup the database via sPIP Cpanel. I'm using SPIP 1.0.2d
> 11132 and the latet version of MYSQL.
> Any help?
> Regards
> Kamran_______________________________________________

5

SPIP shouldn't include the spip_cache and stats and index tables in the dump. But if you do it from phpmyadmin, then u'll get all these tables.

george@diwanalarab.com wrote:

Hi

I don't think SPIP includes spip_cache or the visits in it's dump. Having said that, I am not sure anymore, I have a site with around 15000 articles, loads of authors and sections etc... last month the size of the compressed dump was around 35 Mb this month (about 100 more articles later) it jumped to 69Mb. So go and figure out.

George

Quoting Gilles Vincent <gilles.vincent@gmail.com>:

Hi,

On Mon, Apr 28, 2008 at 7:23 PM, kamran Mir Hazar
<kamran_mirhazar@yahoo.com> wrote:

But what can we do to fix it? It is important to have back up of the
database for at least each week.

You can find the biggest tables with a mysql admin panel (like phpMyAdmin)
Maybe some tables are too much important but can be flushed :
spip_caches for example : flushing the cache (i the Admin panel)
before dumping can limits the dump filesize.

If you don't use the search functionality, you can disable the
indexation (this flushes the tables spip_index and spip_index_dico)
It's the same if you use a third-party tool for the statistics : think
to disable this functionality in SPIP : it will flush the tables
spip_visites and spip_visites_articles

Finally, try to disable the compression option : maybe it's this phase
that puts a limit to the initial file size.

With such tips, does it work now ?

.Gilles

Any idea?
Kamran

----- Original Message ----
From: L'oiseau2nuit (ex- Zzz.) <loiseau2nuit@no-log.org>
To: kamran Mir Hazar <editora@kabulpress.org>
Cc: spip-en@rezo.net
Sent: Monday, April 28, 2008 7:11:08 PM
Subject: Re: [Spip-en] Backup database

I have the same problem. I think that most of the time it is due to the
spip_syndic table which cast every bit of limk published and the websites
you link to.

For me this was 5 years of backlinking on heavy traffic websites, so....

And by the way, I'm not a specialist but I think 14MB is much too bog for
a dump file.

Good luck.

On Mon, April 28, 2008 6:28 pm, kamran Mir Hazar wrote:

Dear all,
I have faced an issue regarding backup the database. When I wanted to save
the database it is going so slow and I cannot load the page. The hosting
company says it is because of large files of dump. But I don?t think the
compressed backup would be more than 14MB.
I cannot backup the database via sPIP Cpanel. I'm using SPIP 1.0.2d
11132 and the latet version of MYSQL.
Any help?
Regards
Kamran_______________________________________________