Server:
mysql.puroparty.com
Database:
puroparty
Structure
SQL
Export
Search
Query
View dump (schema) of database
Export
ads_ad_types
ads_ads
ads_banner_groups
ads_banners
ads_categories
ads_coupons
ads_coupons_lock
ads_statistics
ads_system
artists
asLinks_categories
asLinks_config
asLinks_links
bak_banner
bak_bannerclient
bak_bannertrack
bak_categories
bak_components
bak_contact_details
bak_content
bak_content_frontpage
bak_content_rating
bak_core_acl_aro
bak_core_acl_aro_groups
bak_core_acl_aro_map
bak_core_acl_aro_sections
bak_core_acl_groups_aro_map
bak_core_log_items
bak_core_log_searches
bak_groups
bak_menu
bak_menu_types
bak_messages
bak_messages_cfg
bak_migration_backlinks
bak_modules
bak_modules_menu
bak_newsfeeds
bak_plugins
bak_poll_data
bak_poll_date
bak_poll_menu
bak_polls
bak_sections
bak_session
bak_stats_agents
bak_templates_menu
bak_users
bak_weblinks
bd_world_cities
bd_world_countries
bd_world_regions
bos_ad_types
bos_ads
bos_banner_groups
bos_banners
bos_categories
bos_coupons
bos_coupons_lock
bos_statistics
bos_system
bosdevUUS
cooking
djs
email_autoresponders
email_banned_emails
email_config_settings
email_customfield_lists
email_customfields
email_form_customfields
email_form_lists
email_form_pages
email_forms
email_jobs
email_jobs_lists
email_links
email_list_subscriber_bounces
email_list_subscribers
email_list_subscribers_unsubscribe
email_lists
email_log_system_administrator
email_log_system_system
email_module_tracker
email_modules
email_newsletters
email_queues
email_queues_sequence
email_queues_unsent
email_segments
email_settings
email_settings_cron_schedule
email_stats_autoresponders
email_stats_autoresponders_recipients
email_stats_emailforwards
email_stats_emailopens
email_stats_linkclicks
email_stats_links
email_stats_newsletter_lists
email_stats_newsletters
email_stats_sequence
email_stats_users
email_subscribers_data
email_templates
email_user_access
email_user_permissions
email_user_stats_emailsperhour
email_users
extcal2_categories
extcal2_config
extcal2_events
extcal2_groups
extcal2_plugins
extcal2_templates
extcal2_users
extcal_1categories
extcal_1config
extcal_1events
extcal_1groups
extcal_1plugins
extcal_1templates
extcal_1users
extcal_2categories
extcal_2config
extcal_2events
extcal_2groups
extcal_2plugins
extcal_2templates
extcal_2users
extcal_categories
extcal_config
extcal_events
extcal_groups
extcal_plugins
extcal_templates
extcal_users
jos_banner
jos_bannerclient
jos_bannertrack
jos_categories
jos_components
jos_contact_details
jos_content
jos_content_frontpage
jos_content_rating
jos_core_acl_aro
jos_core_acl_aro_groups
jos_core_acl_aro_map
jos_core_acl_aro_sections
jos_core_acl_groups_aro_map
jos_core_log_items
jos_core_log_searches
jos_groups
jos_menu
jos_menu_types
jos_messages
jos_messages_cfg
jos_migration_backlinks
jos_modules
jos_modules_menu
jos_newsfeeds
jos_plugins
jos_poll_data
jos_poll_date
jos_poll_menu
jos_polls
jos_sections
jos_session
jos_stats_agents
jos_templates_menu
jos_users
jos_weblinks
kxtn
lyrics
mega101
networkgirls
phorum_banlists
phorum_files
phorum_forum_group_xref
phorum_forums
phorum_groups
phorum_messages
phorum_pm_buddies
phorum_pm_folders
phorum_pm_messages
phorum_pm_xref
phorum_search
phorum_settings
phorum_subscribers
phorum_user_custom_fields
phorum_user_group_xref
phorum_user_newflags
phorum_user_permissions
phorum_users
photopost_admingroups
photopost_admlog
photopost_cache
photopost_categories
photopost_comments
photopost_ecards
photopost_exif
photopost_extrafields
photopost_favorites
photopost_ipcache
photopost_iponline
photopost_laston
photopost_notify
photopost_photoextras
photopost_photos
photopost_photoviews
photopost_settings
photopost_sort
photopost_sortmemb
photopost_usergroups
photopost_users
pics
poll_comment
poll_config
poll_data
poll_index
poll_ip
poll_log
poll_templates
poll_templateset
poll_user
radio
test
top40vids
users
users2
videos
vids
wp_1_comments
wp_1_links
wp_1_options
wp_1_postmeta
wp_1_posts
wp_1_term_relationships
wp_1_term_taxonomy
wp_1_terms
wp_2_comments
wp_2_links
wp_2_options
wp_2_postmeta
wp_2_posts
wp_2_term_relationships
wp_2_term_taxonomy
wp_2_terms
wp_3_comments
wp_3_links
wp_3_options
wp_3_postmeta
wp_3_posts
wp_3_term_relationships
wp_3_term_taxonomy
wp_3_terms
wp_4_comments
wp_4_links
wp_4_options
wp_4_postmeta
wp_4_posts
wp_4_term_relationships
wp_4_term_taxonomy
wp_4_terms
wp_5_comments
wp_5_links
wp_5_options
wp_5_postmeta
wp_5_posts
wp_5_term_relationships
wp_5_term_taxonomy
wp_5_terms
wp_7_comments
wp_7_links
wp_7_options
wp_7_postmeta
wp_7_posts
wp_7_term_relationships
wp_7_term_taxonomy
wp_7_terms
wp_8_comments
wp_8_links
wp_8_options
wp_8_postmeta
wp_8_posts
wp_8_term_relationships
wp_8_term_taxonomy
wp_8_terms
wp_9_comments
wp_9_links
wp_9_options
wp_9_postmeta
wp_9_posts
wp_9_term_relationships
wp_9_term_taxonomy
wp_9_terms
wp_blog_versions
wp_blogs
wp_registration_log
wp_signups
wp_site
wp_sitecategories
wp_sitemeta
wp_usermeta
wp_users
Select All
/
Unselect All
SQL
LaTeX
CSV for MS Excel data
CSV data
XML
SQL options
Add custom comment into header (\n splits lines):
Enclose export in a transaction
Disable foreign key checks
Structure:
Add DROP TABLE
Add IF NOT EXISTS
Add AUTO_INCREMENT value
Enclose table and field names with backquotes
Add into comments
Creation/Update/Check dates
Data:
Complete inserts
Extended inserts
Use delayed inserts
Use ignore inserts
Use hexadecimal for binary fields
Export type:
INSERT
UPDATE
REPLACE
LaTeX options
Include table caption
Structure
Table caption
Continued table caption
Label key
Data:
Column names
Table caption
Continued table caption
Label key
Replace NULL by
CSV options
Fields terminated by
Fields enclosed by
Fields escaped by
Lines terminated by
Replace NULL by
Put fields names at first row
Excel options
Replace NULL by
Put fields names at first row
Excel edition:
Windows
Excel 2003 / Macintosh
XML
This format has no options
Save as file
File name template:
(
remember template
)*
Compression
None
"zipped"
"gzipped"
"bzipped"
*
Use __DB__ for database name, __TABLE__ for table name and
any strftime
options for time specification, extension will be automagically added. Any other text will be preserved.