vb.org Archive
Page 44 of 53 « First 344243 44 4546 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3 Articles (https://vborg.vbsupport.ru/forumdisplay.php?f=187)
-   -   Tutorial: How to run vBulletin onto your PC (https://vborg.vbsupport.ru/showthread.php?t=39482)

X-Sector 02-10-2004 10:59 PM
Well, I just tried to connect to my database without a user and password but l got this error..

Attempting to attach to database...

Connect failed: unexpected error from the database.

Error number: 1044

Error description: Access denied for user: '@localhost' to database 'vbulletin'

Please ensure that the database and server is correctly configured and try again.

Click to go to the vBulletin website

I tried to connect to my database with a user and password but it said that it cant connect to my database. What did l do?

blakkboy 02-15-2004 03:16 AM
this is where im stuck

04. Open a CMD window and change it's location to your current MySQL /bin folder.

05. Set your Users:
\bin> mysql --user=root mysql
mysql> GRANT ALL PRIVILEGES ON *.* TO monty@localhost
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO monty@'%'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT RELOAD,PROCESS ON *.* TO admin@localhost;
mysql> GRANT USAGE ON *.* TO dummy@localhost;

i dont understand what the CMD window is and where to set your users

also mysql admin is not on for some reason....... its running a red light and i take it that the light is supposed to be greeen

Dean C 02-15-2004 08:08 AM
I think in the mysql > bin folder there's an exe where you can execute mysql queries within a DOS interface :)

blakkboy 02-15-2004 04:44 PM
^^^ ok thanx i seem to have gotten it now

blakkboy 02-16-2004 01:02 AM
Quote:
Originally Posted by Velocd
Quick Tutorial - How to backup/restore on a localhost

I thought I would make this because I fought alittle trying to get this working using the MSDOS shell, and found some things to be alittle different than from what backing up is usually like.
Once again, thanks to FWC for the tip, and also Logican from another post providing me some info

(note: done using Windows XP, should work on older OS also)

----------------------------------------------------------------------------------------

1. Copy and paste the following into your address bar, then hit enter: %SystemRoot%\system32\cmd.exe

2. Now depending on how you installed MySQL on your system, either with or without PHPTriad, you need to browse to that directory bin folder.

For example, if you did use PHPTriad, type cd c:\apache\mysql\bin.


3. For BACKING UP:

Type mysqldump -u username --opt database_name > backupfile.sql, filling in username and database_name with the correct values.

This method worked perfectly for me using the PHPTriad installation, should do the same with the other. If it asks you for a password, enter the password.


4. For RESTORING:

Type -u root -ppassword database_name < backupfile.sql in the command prompt.

You might get an error saying a table already exists, if so you need to clear your current database. Go into phpmyadmin and drop it that way. Be sure not to drop the whole database eliminating it, but just dropping the tables. Before doing this check your database backup you just created to make sure it actually created its and is not corrupt.

Thats it!

im having trouble trying to restore my sql file from my real boards to my test ones.

-root -password vbulletin < blakkboy_vb.sql

that is what im typing into the prompt but its saying that its not restoring.

can someone help me out who used triad to set this up?

blakkboy 02-17-2004 08:12 PM
could someone let me know what exactly i did wrong so i can import my db to my computer forums

Andreas 02-17-2004 08:34 PM
Try

mysql -u root -p vbulletin < blakkboy_vb.sql

blakkboy 02-17-2004 09:00 PM
^^^^^^^^ your a life saver, thanx buddy

Lexx 02-17-2004 09:48 PM
Hi

I'm working on getting a handle on vB3 and have it running on my local computer so I can make forums and adjust "things".

A fresh untouched vB3 is sitting on a remote live server with several test messages on it.

What files and/directories do I need to upload from my home computer with the modified forums to update the live vb3 on my remote server so it looks and act like my finished version from my home computer?

I want the appearance of the remote vB3 to be the same as the "adjusted" home version of vB3, but I don't want the new adjusted vB3 (with new forums etc.) to mess up the database on the live server

How do I handle this merging of live database on the remote server with the newly adjusted vB3 uploaded from my localhost machine?

Any help is appreciated. I'm pretty new at this stuff

Thanks

Andreas 02-17-2004 10:00 PM
I'd do the following:

1) Make sure both run the same version
2) Shut down the live board
3) Make a backup of all files and the database (just in case anything goes wrong)
4) Upload all files form your test board
5) Export style & language from your testbord
6) Import both at your live board
7) If you made changes to the database structue do the same changes to the live system
8) Check if everything is ok
9) Open the live board


All times are GMT. The time now is 04:43 PM.
Page 44 of 53 « First 344243 44 4546 Last »
Show 40 post(s) from this thread on one page

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

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01631 seconds
  • Memory Usage 1,745KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete