News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

Anyone willing to test some things for me?

Started by [Unknown], October 17, 2004, 01:22:35 AM

Previous topic - Next topic

[Unknown]

I'm afraid that this utility doesn't currently very cleanly handle DOWNGRADING from 4.1.x to 4.0.x...

You'll want to use mysqldump with the compatibility options on.

-[Unknown]

nokonium

I've been using the backup tool for a while and I've just tried to use the restore_backup tool to load a database to my test site. I have tried compressed and uncompressed and it never seems to complete step 2.

Using restore_backup.php: 'Software Version: SMF 1.1 Beta 1'                         



[Unknown]

Give it time.  If you want, you can try phpMyAdmin instead.

-[Unknown]

nokonium

I have tried phpMyAdmin, with a gz compressed file of circa 4mb, it uploads and then I get a 500. So I have done an uncompressed one. Uncompressed the database file is 14mb which rules out phpMyAdmin unless I chop it up.

I let resore_backup run for at least 30 minutes.



nokonium

I think I have found out what the problem was, the ftp transfer mode. I have changed it from binary to ascii and retransfered all the critical files. Restore_backup.php now runs and can be seen to be running.



Grudge

Just thought I'd say I used the backup restore script for the first time yesterday and it worked great! Though the SQL file was only about 15MB, phpMyAdmin couldn't handle it yet this tool did a brilliant job!
I'm only a half geek really...

nokonium

Been thinking, I know that can be dangerous for the over 50's BUT (isn't there always a big but?)

After sussing out what was wrong (see above) I am now trying to give my SMF test site a database which is a copy of the main board but with a different table name (damage limitation). Is it possible for you to include code to do this in your restore_backup.php?

I was thinking along the lines of being able to specify the table reference/name that you restore it too.



RGSMDNR

cant seem to find the back up..

anyway to make it save to the desktop?




kisii

what woudl cause a 500 internal error ...restoring a 10.8mb .zip file?

jetli68

hi can anyone help a newbie and tell me where to put these 2 files  so they would work

cheers

jet

nokonium

I have created a backup folder in the main SMF folder and keep the files and the backups in there. If you are going to transfer the files anywhere by FTP, set sql & sql.gz to ascii mode (I also have txt, php & css set to ascii mode as well)



[Unknown]

Umm.... .gz should definitely be binary, not ascii.

-[Unknown]

Gotti

I keep getting the error that it cant login with the info supplied, but when I go to phpmyadmin with the same info, it logs me right in. Is there a specific place to put the php file when I run it?

nokonium

I have mine in a folder called backup, where I store the last 3 d/b backups. They get downloaded when I do a files backup.

I've had this problem in the past and never found the reason. I stopped getting it when I moved to another host, which suggested to me that the problem is being caused by the server configuration.



kisii

anyone might knwo why im getting this error when trying to upload the database to the new server?

Some of the queries were not executed properly. Technical information about the queries:
Line #212: Query was empty
Line #245: You have an error in your SQL syntax near '���!�T�_&���@���T�L)���Q�q��^
%%�f(�
��@�dK��x��9�)1J�c��1�����S�����' at line 2
Line #555: You have an error in your SQL syntax near 'Z�N���������%S���Q]�
���~ak/��H`���wu�����|�6�î���^IpP�s<x⊚�W�kLr' at line 2
Line #566: You have an error in your SQL syntax near '��XO��=S�Gô�>l$�0FV��[A��
�my��\���p�3� ��: �]H``��sY.�3�,,�t�~' at line 2
Line #1162: You have an error in your SQL syntax near '��^���)��' at line 2
Line #1504: You have an error in your SQL syntax near 'fWkB�>0�b��)QcXRn{�
BK��t`A�2�\�.�z:ה�9��WCt9��ތ-��ȒPCt��� B�h�' at line 2
Line #1620: You have an error in your SQL syntax near '�,�u�A4`��?v���8.=��ڈ��4� ��[
L"&>=[f��L���(8��U' at line 2
Line #1746: You have an error in your SQL syntax near 'lʡ^R^D�7��$�m^l���$n�9�е7���6��(�<���W�T*̹�nTB�-�Q�����w0�x- K��%' at line 2
Line #2441: You have an error in your SQL syntax near '��������-޸�������W��M�pZ�ȹ2Tܔ���4G{�Us�|Ǯ�-�7p`0��\Z`��
zп�]wDO��' at line 2
Line #3136: You have an error in your SQL syntax near '�#����8' at line 2
Line #3176: You have an error in your SQL syntax near '?{�b� ��,���Z��P\{@��!q{x}|�vx���=p�=�O�&�Vfz�0��>�� ���I��' at line 2
Line #3355: You have an error in your SQL syntax near '��&�x:�V����}�e5s+�4�v҇>U^���}�&�� .O�}�"]пX�A�딐�/��thF������?��' at line 2
Line #3610: You have an error in your SQL syntax near 'Se���F' at line 2
Line #3744: You have an error in your SQL syntax near '�gZ*��p5�B�xf��`~ZDH�1��*i�� ���Z�ЅA���a^�
���Jy� 5k
2
u�*�' at line 2
Line #4010: You have an error in your SQL syntax near 'qƗ�1E( ڌ��S=R �L�='GD��0�v�m�� �gO' at line 2
Line #4217: You have an error in your SQL syntax near '=s' at line 2
Line #4223: You have an error in your SQL syntax near 'Ρ^w
�+�y��_yQ&�=.�R����TRW�^�U�V0;�e��Scz*�_�-�/�ԕ;)/' at line 2
Line #4256: You have an error in your SQL syntax near '&�zEP�'��/1ؕ��?�����S' at line 2
Line #4427: You have an error in your SQL syntax near '�P�Li @�.D�pp)���'G@���^@��y2� ��1�e' at line 2
Line #4628: You have an error in your SQL syntax near '��Mγ��<s�6�2ضEޜ6���
l��P�' at line 2
Line #4705: You have an error in your SQL syntax near '�?�!
?*^�-������t:6��`���d' at line 2
Line #4740: You have an error in your SQL syntax near 'W' at line 2
Line #5492: You have an error in your SQL syntax near '���YG� ͩ0' at line 2
Line #6143: You have an error in your SQL syntax near '�������F��
��PZ��h���ɇ����A���-�=�h�$�
��p�:bAk�H㭀�MR��ϔ�ǝ���/g9eM' at line 2
Line #6632: You have an error in your SQL syntax near '�"��jW}��z�oN 4>7���;~���˝��� �\7���S�!$CIaڀz�O
��\M.�MA������' at line 2
Line #6678: You have an error in your SQL syntax near '�sA��mx�1y/e�
�#��nk��-ι.ƾÄkc��%�&(Žܛ��e�/�`�7%�L���O4x�Ъ�&' at line 2
Line #7418: You have an error in your SQL syntax near 'gh��6�F�l���Ow�/���d"����GE4�8��C�L$��]��9j �k(U��r0����f�D`A���q�8' at line 2
Line #7566: You have an error in your SQL syntax near 'O"ҏ��,��]��\�;��6ҽnL��k���:~\v�
W���M�O8
1J ��plx��(�Ȉ�##�*�"���g3���' at line 2

FBI

restore_backup.php and creater_backup.php its nice scripts from UNKNOWN to backup and restore MySQL database :)
But its only work, if you have enough space on your host. My hosting server have not enough space to create the dump files. And PHPMyadmin cannot do the help (memory limited, time out issue). But, my host server gave the unlimited SQL file. I want to replicate the database in to new prefix (for example from smf_database to new_ database)

So, I seen every installing or upgrading new SMF version. There is a copy function/procedure from old database to backup (before upgrade). Which script (from installation files) that I can use to copy/replicating the database?

Thank you for your help

peta-sucks.com

Ok I installed this in my smf folder and when I run it it jumps up to 84% real fast and stops.

Advertisement: