Creating a DB

 
Post new topic   Reply to topic    Aprelium Forum Index -> Databases
View previous topic :: View next topic  
Author Message
JohnT2007
-


Joined: 08 Nov 2004
Posts: 9

PostPosted: Thu Jun 22, 2006 12:54 am    Post subject: Creating a DB Reply with quote

Hello

For the first time in my life, I was actually able to install mysql and make it...well install properly anyway.

My question is, now that it is installed, how do I actually make, edit, delete, databases. Stuff like that. Not sure exactly where to go once I have it installed. Could anyone please help me out? Thanks in advance.

John
Back to top View user's profile Send private message
cmxflash
-


Joined: 11 Dec 2004
Posts: 872

PostPosted: Thu Jun 22, 2006 1:16 am    Post subject: Reply with quote

3 sec on Google gave me this page:

http://www.webdevelopersnotes.com/tutorials/sql/index.php3
Back to top View user's profile Send private message
JohnT2007
-


Joined: 08 Nov 2004
Posts: 9

PostPosted: Thu Jun 22, 2006 2:04 am    Post subject: Reply with quote

Im not retarded, I google before I ask.

I dont have anything about mysqld --standalone or whatever it was. I used the msi installer. There is nothing like that in the bin folder like it tells me to look for.
Back to top View user's profile Send private message
aprelium
-


Joined: 22 Mar 2002
Posts: 6800

PostPosted: Thu Jun 22, 2006 11:58 am    Post subject: Re: Creating a DB Reply with quote

JohnT2007,

We highly recommend installing PhpMyAdmin as it allows you to do all the database manipulations using a relatively nice and easy to use interface.

Check the tutorial in http://www.abyssunderground.co.uk/tutorials-phpmyadmin2-8-0-3.php .
_________________
Support Team
Aprelium - http://www.aprelium.com
Back to top View user's profile Send private message Send e-mail
JohnT2007
-


Joined: 08 Nov 2004
Posts: 9

PostPosted: Fri Jun 23, 2006 5:07 am    Post subject: Reply with quote

Thank you so much! I got phpmyadmin up and running, but now I have another question....

I am trying to import a database....that is well over the 2,048KB limit.... its a forums database that we are using a webserver for to make changes for a site revamp, so we want to do it off the server to keep the cluster of new files, away from the old ones. We are completely redoing a network of sites....

so.... I need to import this forum database into one I made.... how do I go abouts doing that? The sql backup from the forums is 22.8 megs....can anyone provide any assistance?
Back to top View user's profile Send private message
aprelium
-


Joined: 22 Mar 2002
Posts: 6800

PostPosted: Fri Jun 23, 2006 1:09 pm    Post subject: Reply with quote

JohnT2007 wrote:
I am trying to import a database....that is well over the 2,048KB limit....


This limitation is imposed by PHP and can be changed by modifying some parameters in php.ini. Please read http://www.aprelium.com/forum/viewtopic.php?p=37831#37831 for more information.
_________________
Support Team
Aprelium - http://www.aprelium.com
Back to top View user's profile Send private message Send e-mail
JohnT2007
-


Joined: 08 Nov 2004
Posts: 9

PostPosted: Fri Jun 23, 2006 8:12 pm    Post subject: Reply with quote

Great so far, this should be my final question :-)....

What I am trying to do is import a forum database as said, the sql file is being put out by vBulletin, so in theory, there should be no errors with it. Upon trying to import the database, after a while this is what i get:

Quote:
Error
There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:
----BEGIN CUT----
eNqdlXlQk0kWwCskWJCykCCIlAhNGQyQwy/hCISiEDAhwRhCEiLGZiRyGVcCJAHEcXYFvAcYEJFD
C1cNiAqs3MrgDA4ioOCCciOuGUDwwBEYVESX/ZJld+a/Pfr7+n3vq379Xv9ed9dji0TBIhYIoIMA
BuCzBSzg6oGgnQ7o7m5MvFiCDq7D4wOkYhYg8qJYQJ14IEGuUkeraAcUe2kJ+xIoyYBBc2MCBoJ4
bEHoW+hMQGeyEAbLFQGRqXvjNXs0cYB9MAEQ8TtSxSF8FnCnITQGgxoZHxeXpFRoUqlKDT5ULALB
YgrwC2QLJBQgZaNxdyqUYEewjMfn++nn4IU7/FhoLE90uiteyBXqrSjBYr1DOs0N7OQJBBI8308Q
yALRSmqSJobqiTcExPMEYrZIAngCSTCITFJr4uPkyXKNXAWkfvxQttiJ5I6QKIC0PLT8HCLmQRwe
ByIYDERQaXghsjwKkQBUUUGliQnagV6DSlNUqFYbdBXB1oKwZg0Bbk5Mitd420CZpa0zkeziRIQk
SKIytjKpiA+i1z35Xj4BbC6PS/YIDhVwJFsDuWyDf4zek4qwhuBgYeHApkESjf0/t+UWiBBMIOIN
ESEWs7IYiBgRMFgCZvkeROwNWMYYQ9Prv38wRlic8SpgYuCCSr19vTk6G4PFGuGwxsY4nMHqG9QO
IjiCsYUD3W/V2hA5WAmUaMlIy71kssm/+q6VqPcd0XWvKh31tc56PZoPx83yuARvSHJydnFz92B6
erECtrE5gVxekFgSKt0ZtksWGRUdE7tPsV+tSUpOOZh6KOPoseMnTp46fSbvbP65gsKi4stXtKVl
V8uvXa+pratvaLx1u+mn1ntt99s7Oh88ftLXPzA4NDyi+3l8YvLF1PTLV7Nz878uvP/wcfGTARyl
xWL+1f4TNUFPbYTDYXHAQI0xSjEYEnDGDvRVFn4hQJ64doWakWZi6Z97qfqu6SZX0TurvapeFJno
pnOcNXD/hv3fUaf/X9j/pv4NegQiq9EzgG4+FsXxhcgU9SpBkBb2ecwyE8pe/jrzx4Ox1CmoegOV
k+fLBAJfF11EH+6MLgNgNzSl7ZZJB/JLjcOcn5qpMJVelbeLj43lzhSrmxtCOt5GxW5ojAO2n2Lr
w2IlNslQ6fOI/IA4UDWs9rgKST688/YDN8L3m7fccLynfTu9fV0358UrqLKr/lIa/QK3BOGGzpY9
SFRx+4D7w6jRdcyNbeG2kXbHm9+PimqbYsxnVjdPrfc9tvPW4NEqq+b2UN8xG98shWUV/0rZi4dj
rYwK13MArCmxXoZIpURwBaoq0x/GrWxGXVoRVJaErf289ZCmYtjdMYz/3CIzwRoi6gvj7lIfkdfm
AxrvudnFiCNWkmxBYps4J9+XnsIlTjY2BI95oWvPIruW9eUSuYPolt2eavyq/y9uwpeDOSY96eaZ
/Tv89zyzbq1lRJwR7N4InugXEPJ18dzQxFmo+mtdSWrHG3LZY/DoIpRxr1hMnl7SWH27Ksu56PDL
nm1eEUffbo7VeI+RtVvHI8tHR7P9T3d2SJ73jyK/VOoHujfF2VO3X6NDmdmZ10e4ubz2K9LS7qON
NZZpzAZGapt1ycYfz7NrGrl5Xaee5kShN/CiTPt4A/+SrpF6Y/fx6d7Oj+/+gHQ9tDxqZ1WdF244
dnl/3iP7api3khsw13qiNWPQ8zpU6SoD3nxwifyOpsv7kNHXr676eTKZTC7oLbCfn/3u8XVF8sw3
Fbv9zRi6wk+Yzr+H1sdfHisrGZhwSCqK0dUYZTc/afYufSivClIaKcOYmUyI0NFcvBa9sCf3PP0+
NE/ocIJtfyxqf3kKp3ohgqPuMSurB4k+E1UsZUv7YfFEbZZWoaUlsKDybDdlb2X96wulhRDOz7vv
ym4XQlig401K+q+5a0cuRWV7QFJuVpcvX9IakjOliMH2owd5vryG39030LYPjVoXWWSzArgtbGmL
/yH1Tt2d77euO/itWZe3yHQ8/4cUMvCEyhOJkPQOkqy0Da+Eh4c/rCrXxmwvD74T5GSrafMzZEvb
2159OeJrL1v7+w3dTXaM/V4USXbYeE8xpSkr3Pbzoa7Z2gOEHM5TTOe1usXwuC1bqsyG3/IgvNm+
ESJW14ghu4/cqLOXD9xc2HDR01LaMpYxb/YsYyAXNalVrD+F6bD/xcNF0nQqdl9mz7n7yTS1cNTv
5OIjek9ftZNNNETsFGmFuaMUlKk53UN5CyIXlvrm9OfV2+gBlNGHU9CRhemRUrmnjc/Sk4rKS1TK
fSQKwiP3L7d7Zzc41p/DLYL8kPPVE3kzst4HEKI3I9/nbgVDvfoEWti0E2hdKD4zHDg0WfDxpwi0
QhX3dIcqhqaFz9cUfgk+lL1r183rXX8T1G8XJOcSzdrS3zH2v7bImBzXLwHKHn8I3Ba+4NK9dpFi
7XBnh5Dl4j7SESsV3Zszsx6sj6utyTZ9efpktWl7hIKx4FpV8YwYfVy38dajnmHsrNF1p4NHROps
LxxBWvXW0X8SwnSV6YIV5z2HOPFFd2vpgkjZ8qflYX0ZpiOeHkxXBt3VS//XMfMADM1M0GlBwkDD
qEEwGQz9F/mncPb+Bxnjrz8=
----END CUT----
----BEGIN RAW----

ERROR: C1 C2 LEN: 360 361 1547
STR: 

CVS: $Id: sqlparser.lib.php,v 2.47 2006/01/17 17:02:30 cybot_tm Exp $
MySQL: 5.0.22-community-nt
USR OS, AGENT, VER: Win MOZILLA 5.0
PMA: 2.8.0.3
PHP VER,OS: 5.1.4 WINNT
LANG: en-utf-8
SQL:
INSERT INTO customavatar VALUES('50', '����\0JFIF\0\0\0\0\0\0��\0C\0\r\n\n \r\n\n \n\r \r\n\r\"\Z)$+*($\'\'-2@7-0=0\'\'8L9=CEHIH+6OUNFT@GHE��\0C \r\r!!E.\'.EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE��\0\0;\0P\"\0��\0\0\0\0\0\0\0\0\0\0\0  \n\r\n��\0�\0\0\0}\0!1AQa \"q2���#B��R��$3br� \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz���������������������������������������������������������������������������\0\0\0\0\0\0\0\0  \n\r\n��\0�\0 \0w\0!1AQ aq\"2�B���� #3R�br�\n$4�%�\Z&\'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz��������������������������������������������������������������������������\0 \0\0?\0�-�N�X���\Z���~xg-�\r�\n囦NN?*�`��� ��[ZV֕�X)�r�9����ݑ�s��Q��dg�m �g�XgTv\n=�+�$֮�s6�\'=I�֫]j�%Ĥ��K�F��\r��e��\\��_0d���5�d�7�]c����R��f� ��?�W�ׄ���U?�?�i�L������2�3� ��\0�TN�\r���m\"���\n�X�@zt��5%XL��p\0s��5V=R9<���`�T�Nq�S��?1wH$巶O�9\'=�+3�ԑ$H�\'(��^կ4P�אЂ��MB_�ó2`�N[ ��\0�Q{����\rϴ�y��+�� Ο\ZH���t��)�|��D9`��>�+�@�c��ێB���T���0�>�#m-K�1\Z��H�IǣV�̈́���7�2y����E��H�̉ܐd\0�Z��L��-�[������k0�����]&��_Z^�I\" �ÇÃ�8�\r�C��*c�.����s���v++�ї��Ҫiv�}�[B2����U�o�ݦ���!u�f���Ӽ;��a�JnnX7�7\01�\0�R�+�ܻU�P!�E�dj�wF��`Fs��� q=�:n��|S䳍�i�.p:\n��,b��뜥�\\��5Y��P\\��I�Tթ5�ڡd�6\'���?LT�Q��if�\0��L����h�\0�c�\"DX�/BzsWύ@x��;R 㕾w+ 8\n�q\'�\'���P|����fK�O�J(t�A&��DZ�`{9ƶͺ2j9,T�X�К,��]�z��l�F�ɩ��]m//���I\\��\0�$Q[���aְ��8V�݃�ރ֑I\\�i���6*T��gh�Ж�v.sP�A���1�Ա(e\0i����,�\0��6n�\0����<;�\Z1�w�\0��ڥa8=�Ӭ��-,�0d\\�Ƣ�;��%��� �Q����Z��\\\r��=�2s �\0��\0;���G����`\Z���Ui��P���Oz�YY����N�KNv�$ł�2j����<\Z��GD]�*��,!�MP:*5��gVR��׵m��� 銈� �`i2�3���$e��������(x�Rs�9V��%B�\\�r �F�F$����Rn���', '1086732139', '��� ���1.JPG', '1', '1722', '0', '0');

----END RAW----

SQL query:

INSERT INTO customavatar VALUES('50', '����\0JFIF\0\0\0\0\0\0��\0C\0\r\n\n \r\n\n \n\r \r\n\r\"\Z)$+*($\'\'-2@7-0=0\'\'8L9=CEHIH+6OUNFT@GHE��\0C \r\r!!E.\'.EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE��\0\0;\0P\"\0��\0\0\0\0\0\0\0\0\0\0\0  \n\r\n��\0�\0\0\0}\0!1AQa \"q2���#B��R��$3br� \n\Z%&\'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz���������������������������������������������������������������������������\0\0\0\0\0\0\0\0  \n\r\n��\0�\0 \0w\0!1AQ aq\"2�B���� #3R�br�\n$4�%�\Z&\'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz�������������������������������������������������������������������������� \0 \0\0?\0�-�N�X���\Z���~xg-�\r�\n囦NN?*�`��� ��[ZV֕�X)�r�9����ݑ�s��Q��dg�m �g�XgTv\n=�+�$֮�s6�\'=I�֫]j�%Ĥ��K�F��\r��e��\\��_0d���5�d�7�]c����R��f� ��?�W�ׄ���U?�?�i�L������2�3� ��\0�TN�\r���m\"���\n�X�@zt��5%XL��p\0s��5V=R9<���`�T�Nq�S��?1wH $巶O�9\'=�+3�ԑ$H�\'(��^կ4P�אЂ��MB_�ó2`�N[ ��\0�Q{����\rϴ�y��+�� Ο\ZH���t��)�|��D9`��>�+�@�c��ێB���T���0�>�#m-K�1\Z��H�IǣV�̈́���7�2y����E��H�̉ܐd\0�Z��L��-�[������k0�����]&��_Z^�I\" �ÇÃ�8�\r�C��*c�.����s���v++�ї��Ҫiv�}�[B2����U�o�ݦ���!u�f���Ӽ;��a�JnnX7�7\01�\0�R�+�ܻU�P!�E�dj�wF��`Fs��� q=�:n��|S䳍�i�.p:\n��,b��뜥�\\��5Y��P\\��I�Tթ5�ڡd�6\'���?LT�Q��if� \0��L����h�\0�c�\"DX�/BzsWύ@x��;R 㕾w+ 8\n�q\'�\'���P|����fK�O�J(t�A&��DZ�`{9ƶͺ2j9,T�X�К,��]�z��l�F�ɩ��]m//���I\\��\0�$Q[���aְ��8V�݃�ރ֑I\\�i���6*T��gh�Ж�v.sP�A���1�Ա(e\0i����,�\0��6n�\0����<;�\Z1�w�\0��ڥa8=�Ӭ��-,�0d\\�Ƣ�;��%��� �Q����Z��\\\r��=�2s �\0��\0;���G����`\Z���Ui��P���Oz�YY����N�KNv�$ł�2j����<\Z��GD]�*��,!�MP:*5��gVR��׵m��� 銈� �`i2�3���$e��������(x�Rs�9V��%B�\\�r �F�F$����Rn���', '1086732139', '��� ���1.JPG', '1', '1722', '0', '0');

MySQL said: Documentation
#1406 - Data too long for column 'filename' at row 1


Any help forr this one? Or a way to get around it?
Back to top View user's profile Send private message
aprelium
-


Joined: 22 Mar 2002
Posts: 6800

PostPosted: Sat Jun 24, 2006 4:11 pm    Post subject: Reply with quote

JohnT2007,

The error message is:

Quote:
#1406 - Data too long for column 'filename' at row 1


It means that one of your columns cannot receive the imported data because of its size.

So you should check your table schema before retrying.
_________________
Support Team
Aprelium - http://www.aprelium.com
Back to top View user's profile Send private message Send e-mail
JohnT2007
-


Joined: 08 Nov 2004
Posts: 9

PostPosted: Mon Jun 26, 2006 9:39 pm    Post subject: Reply with quote

Figured it out! thanks :)
Back to top View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    Aprelium Forum Index -> Databases All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB phpBB Group