View previous topic :: View next topic |
Author |
Message |
JohnT2007 -
Joined: 08 Nov 2004 Posts: 9
|
Posted: Thu Jun 22, 2006 12:54 am Post subject: Creating a DB |
|
|
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 |
|
|
cmxflash -
Joined: 11 Dec 2004 Posts: 872
|
|
Back to top |
|
|
JohnT2007 -
Joined: 08 Nov 2004 Posts: 9
|
Posted: Thu Jun 22, 2006 2:04 am Post subject: |
|
|
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 |
|
|
aprelium -
Joined: 22 Mar 2002 Posts: 6800
|
|
Back to top |
|
|
JohnT2007 -
Joined: 08 Nov 2004 Posts: 9
|
Posted: Fri Jun 23, 2006 5:07 am Post subject: |
|
|
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 |
|
|
aprelium -
Joined: 22 Mar 2002 Posts: 6800
|
|
Back to top |
|
|
JohnT2007 -
Joined: 08 Nov 2004 Posts: 9
|
Posted: Fri Jun 23, 2006 8:12 pm Post subject: |
|
|
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 |
|
|
aprelium -
Joined: 22 Mar 2002 Posts: 6800
|
Posted: Sat Jun 24, 2006 4:11 pm Post subject: |
|
|
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 |
|
|
JohnT2007 -
Joined: 08 Nov 2004 Posts: 9
|
Posted: Mon Jun 26, 2006 9:39 pm Post subject: |
|
|
Figured it out! thanks :) |
|
Back to top |
|
|
|
|
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
|
|