vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Mysql (https://vborg.vbsupport.ru/showthread.php?t=66835)

joaorp 07-04-2004 08:01 AM

Mysql
 
Well, I've made a backup with phpmyadmin on my old host of all tables of my database which resulted in a file of 140 mb .sql

Since I have no more access to my old host the file is way too big to be ran with phpmyadmin, I was wondering if any of you knows a way to do this that will work? :) Like perhaps a php script that will run it or something.

I thank you alot in advance, I've been trying all kind of things this week but was all uncesseded. My last hope is that one of you may be able to help me :)

Modin 07-04-2004 10:25 PM

you can do it with shell access to your site.

upload that 140meg sql file to your site
log in to your site via a shell (ask your host about this if you don't know what it is since it may not be enabled)

run the command (replacing the loginname, databasename, backup.sql with they're respective names)
Code:

mysql -u loginname -p databasename < backup.sql
it should take a minute or 2 to run.


All times are GMT. The time now is 06:09 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.00938 seconds
  • Memory Usage 1,706KB
  • 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)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (2)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