473,730 Members | 2,297 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Copying a table using phpMyAdmin.

4 New Member
2 phpbb boards I run have been hacked. One I've restored but the other one has had some damage to the MySQL db. A table is missing.

As it's a styles table I thought I could could copy a table, from a test board I set up, to the hacked board.

I tried this using phpMyAdmin and I get this error:

Expand|Select|Wrap|Line Numbers
  1. SQL-query: Edit
  2.  
  3. CREATE TABLE `Tabcom`.`phpbb_styles_imageset_data` (
  4. `image_id` smallint( 4 ) unsigned NOT NULL AUTO_INCREMENT ,
  5. `image_name` varchar( 200 ) COLLATE utf8_bin NOT NULL default '',
  6. `image_filename` varchar( 200 ) COLLATE utf8_bin NOT NULL default '',
  7. `image_lang` varchar( 30 ) COLLATE utf8_bin NOT NULL default '',
  8. `image_height` smallint( 4 ) unsigned NOT NULL default '0',
  9. `image_width` smallint( 4 ) unsigned NOT NULL default '0',
  10. `imageset_id` smallint( 4 ) unsigned NOT NULL default '0',
  11. PRIMARY KEY ( `image_id` ) ,
  12. KEY `i_d` ( `imageset_id` ) ,
  13. FULLTEXT KEY `image_name` ( `image_name` ) ,
  14. FULLTEXT KEY `image_lang` ( `image_lang` ) ,
  15. FULLTEXT KEY `image_name_2` ( `image_name` )
  16. ) ENGINE = MYISAM AUTO_INCREMENT = 79DEFAULT CHARSET = utf8 COLLATE = utf8_bin
  17.  
  18. MySQL said: Documentation
  19. #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '79DEFAULT CHARSET  = utf8 COLLATE  = utf8_bin' at line 12 
  20.  
Can you please help?

Thanks
Ashley
Oct 20 '08 #1
6 3528
mwasif
802 Recognized Expert Contributor
Make sure you have space between 79 and DEFAULT in the last line of the statement i.e. 79DEFAULT
Oct 21 '08 #2
AshleyB
4 New Member
Make sure you have space between 79 and DEFAULT in the last line of the statement i.e. 79DEFAULT
Thanks for your quick reply.

However the line was generated by phpMyAdmin not by me; so I cannot correct it!
Oct 21 '08 #3
Atli
5,058 Recognized Expert Expert
Can't you simply copy the SQL you posted here, add the space and execute the modified SQL in phpMyAdmin's SQL window?
Oct 21 '08 #4
AshleyB
4 New Member
Sorry for being so thick!

Where is the SQL window in phpMyAdmin?

Ashley
Oct 21 '08 #5
Atli
5,058 Recognized Expert Expert
If you select the database from the drop-down on the left, there should be a SQL tab at the top of the main window.
That should allow you to run any SQL query you need on the database.
Oct 21 '08 #6
AshleyB
4 New Member
Yes that worked!

I no longer get a db error but my board is still hacked.

Back to the phpbb help forum. :(

Thanks for being so patient with me.
Oct 22 '08 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

0
1774
by: Steve_EE | last post by:
I'm running phpMyAdmin 2.5.3 / MySQL 4.0.14 / PHP 4.3.3 / Apache 1.3.20 phpMyAdmin is installed and appears ok at first, I can login, select databases, view which tables are in each db, see the exact structure of each table, but when I do anything that requires reading of the table contents - browse / select / etc - nothing. If I try browsing a table, the page gets rendered as far as the "Insert" tab along the top, then nothing more. If...
0
1198
by: weldonj | last post by:
I upgraded to MySQL 4.1.1-alpha-standard the other night and ever since then at least twice a day my main message board table will crash. Here's what i get when I check on the board or analyze it: check board: Table Op Msg_type Msg_text myboard.board_data check warning Table is marked as crashed myboard.board_data check error Key in wrong position at page 3072
0
2089
by: Golf Nut | last post by:
This is a phpmyadmin question more than anything, but I hope someone may be able to help. When creating a dump of a normalized database with 26 innodb tables, phpmyadmin export seems to only export the table structure/data in alphabetical order, rather than FK contraint order. Thus when importing the dump of the data, I need to manually go through and select the order to make sure the constraints hold up. Has anyone else seen this? I'm...
2
3361
by: jaks | last post by:
How can I export a MySQL table with a different name using phpmyadmin? I want to export nuke_bbsearch_wordmatch and all it contents to phpbb_search_wordmatch This table in a different db. Fields are the same just the name needs to be changed. When exporting. I have been editting the rest of the table I need manually bt editting them in notepad but the table 4 columns and has 170,000 entries.
1
4086
by: Jim | last post by:
Hi, I want to add a field to a table in a database that is live and being accessed from the web. I'm using phpMyAdmin and when I try to add the field I get error #1142 (ER_TABLEACCESS_DENIED_ERROR) "ALTER command denied to user 'xxx' for table 'yyy'" I'm a newbie to MySQL but I guess that's a reasonable error as there are probably open connections. If that is the reason, is there a way I can force all connections to close and not...
2
5664
by: news reader | last post by:
Hi, Does anoone of you know if there is already a simple application doing something like this. I would enhance / tune the missing features, but would like to avoid to start from scratch or to start from something, that has far too many features and is difficult to setup.
0
2556
by: Howard | last post by:
I have Apache Web Server 2.0.55 installed locally with MySQL 5.0.18-nt, and of course PHP 5.1.2 I also have installed phpMyAdmin. It is accessible through http://localhost/phpMyAdmin. The pathing for directories is C:\Apache\Apache2\htdocs-root folder for Dreamweaver 6.0 otherwise know as MX 2004 I think. C:\mysql, C:\mysql\data-databases including phpmyadmin C:\php C:\Apache\Apache2\phpmyadmin for phpMyAdmin scripts.
2
14483
by: shivendravikramsingh | last post by:
hi friends, i have a problem.i m using phptraid or php4 with mysql and phpmyadmin with apache in window XP my local machine.i hve used phpmyadmin for table creation,deletion,updation and insertion.it work fine earlier,but now when i try to do any operation with a table,its shown a error message,that table is read only. for ex: let i have a table xyz and i want to insert a record on it: it show a erro msg like that: #1036 - table 'xyz'...
2
2235
by: GarryJones | last post by:
(I am sorry if this is the wrong group for this posting, I cant find a group on usenet for phpmyadmin, but maybe someone would be nice enough to answer me anyway....) I need to import data into a simple table The table has three fields. The first is an auto increment value, the second the current time and date (the 14 character version), and a field with some data. This works okay in SQL mode INSERT INTO all_epst VALUES...
0
8770
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9301
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9229
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8184
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6030
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4543
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4801
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3257
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2713
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.