Welcome to Geeklog, Anonymous Friday, March 29 2024 @ 07:13 am EDT
Geeklog Forums
Moving site to new server , which database is correct
Status: offline
garfy
Forum User
Full Member
Registered: 01/02/05
Posts: 437
Location:EU
I would like to know please how to know which database belongs to my site and also to the forum i have inside this site.
On my old server I have 2 geeklog and 3 phpbb forums so I wonder how to know which belongs to which site
thank you
On my old server I have 2 geeklog and 3 phpbb forums so I wonder how to know which belongs to which site
thank you
5
6
Quote
Status: offline
garfy
Forum User
Full Member
Registered: 01/02/05
Posts: 437
Location:EU
I have copied everything that is in public html and changed config file
but now it says error selecting database
i created new database on new server and it doesnt work, i changed the name of the database in config file
but now it says error selecting database
i created new database on new server and it doesnt work, i changed the name of the database in config file
3
6
Quote
Status: offline
garfy
Forum User
Full Member
Registered: 01/02/05
Posts: 437
Location:EU
it is cpanel 10 i guess
i tried to upload my database from previous server that has put the files in rar but this new server i guess doesnt accept that i think it uses notepad files not rar
there is already test database there
and i created new database also the new user and it says no tables found in that database
i used phpmyadmin and i do not know how to upload database there
i can nopt use ftp right??
i tried to upload my database from previous server that has put the files in rar but this new server i guess doesnt accept that i think it uses notepad files not rar
there is already test database there
and i created new database also the new user and it says no tables found in that database
i used phpmyadmin and i do not know how to upload database there
i can nopt use ftp right??
5
6
Quote
Status: offline
garfy
Forum User
Full Member
Registered: 01/02/05
Posts: 437
Location:EU
No it is vdeck
is it possible that i do not have right to make a database
and how to change the username, can i do it alone or do i have to ask for that my host
also i found how to import database but it doesnt work
it was under sql i choose zhe zip file of the database and after a while it says done but there are no databases in the server
is it possible that i do not have right to make a database
and how to change the username, can i do it alone or do i have to ask for that my host
also i found how to import database but it doesnt work
it was under sql i choose zhe zip file of the database and after a while it says done but there are no databases in the server
4
5
Quote
garfy
Anonymous
blue host
and they obviously do not work during weekends
and they obviously do not work during weekends
4
5
Quote
Status: offline
1000ideen
Forum User
Full Member
Registered: 08/04/03
Posts: 1298
Did you find a tutorial on how to use MySQL with cpanel? Search for it.
It requires you to create a database, create a user and to connect both. You can do this all by yourself but you have to do these 3 steps.
E.g.: Look here for tutorials:
https://www.opensourcehost.com/mos452/content/view/9/39/
Also check the .sql file. Depending on the way you exportetd it it may contain a command like CREATE DATABASE which may not work as your webspace already got a database. So try deleting this line then.
The CREATE TABLE command is o.k.
It requires you to create a database, create a user and to connect both. You can do this all by yourself but you have to do these 3 steps.
E.g.: Look here for tutorials:
https://www.opensourcehost.com/mos452/content/view/9/39/
Also check the .sql file. Depending on the way you exportetd it it may contain a command like CREATE DATABASE which may not work as your webspace already got a database. So try deleting this line then.
The CREATE TABLE command is o.k.
3
5
Quote
All times are EDT. The time is now 07:13 am.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content