vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Community Lounge (https://vborg.vbsupport.ru/forumdisplay.php?f=13)
-   -   Any software to view MySQL databases? (https://vborg.vbsupport.ru/showthread.php?t=134931)

RDX1 12-28-2006 01:34 AM
Any software to view MySQL databases?
 
I recently had a problem with my forum, and my database is very large and would take many hours to upload. Is there any software for windows to open .sql files and then extra certain tables? I need one table from the forum database to restore to my web database.

Marco van Herwaarden 12-28-2006 03:01 PM
You can edit the SQL file with any text editor that can handle large files.

A Windows tools for managing database i often use is:
EMS SQL Manager Lite for MySQL

FleaBag 12-28-2006 03:14 PM
I had the same problem as RDX1 - I found Windows wouldn't allow me to open a text file over 200mb. My database is 400mb without avatars and attachments (file system). I will try the program you suggested though!

Marco van Herwaarden 12-28-2006 04:44 PM
If you use a text editor like UltraEdit, you can open files over 1Gb.


All times are GMT. The time now is 07:54 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00904 seconds
  • Memory Usage 1,710KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete