Maintenance script: Created page with " This page describes the procedure to generate all the necessary files to drive the database found in http://mon.iihe.ac.be/OldPnfsFiles/
Note that the password for mysql..."

2015-08-26T12:28:53Z

Created page with " This page describes the procedure to generate all the necessary files to drive the database found in http://mon.iihe.ac.be/OldPnfsFiles/<br> Note that the password for mysql..."

New page

This page describes the procedure to generate all the necessary files to drive the database found in http://mon.iihe.ac.be/OldPnfsFiles/<br>
Note that the password for mysql is to be found in the private 'password' template in quattor.

1) go to maite
<pre>
cd /root/damadori/OldFiles
rm -f *.txt
rm -f all.sql
</pre>
2) go to ccq

<pre>
cd /root/Olivier/Old_pnfs_files
rm -f *txt
rm -f all.sql
</pre>

make sure the file "Storage is up to date. This will be used to go to every storage box

<pre>
./fetch_old
</pre>

3) back on maite

<pre>
cd /root/damadori/OldFiles
./GetOldFilesPath
</pre>

4) back ccq:
<pre>
cd /root/Olivier/Old_pnfs_files
rm -f all.sql
scp maite:/root/damadori/OldFiles/all.sql ./
scp all.sql mon:/root/Olivier/OldFiles
</pre>

5) go to mon
open a browser and point to

<pre>
http://localhost/mysqladmin
</pre>
Log in a root and go to the database '''oldfiles''' and empty the table '''dirs'''. In sql parlance, this would be:
then in a terminal:

<pre>
mysql --max_allowed_packet=100M oldfiles -p < all.sql
</pre>
if the command does not work:

<pre>
mysql -p
set global net_buffer_length=1000000;
set global max_allowed_packet=1000000000;
</pre>
and re-issue the mysql command after leaving mysql.

{{TracNotice|{{PAGENAME}}}}

OlPnfsFiles - Revision history

Maintenance script: Created page with " This page describes the procedure to generate all the necessary files to drive the database found in http://mon.iihe.ac.be/OldPnfsFiles/ Note that the password for mysql..."

Maintenance script: Created page with " This page describes the procedure to generate all the necessary files to drive the database found in http://mon.iihe.ac.be/OldPnfsFiles/
Note that the password for mysql..."