[Tutorial] How to use phpMyAdmin

[MzVette]

Great tutorial!

I have a problem. I attempted to install a portal mod, but received errors. I tried to reinstall where I thought the errors would be fixed, but I got a error that the db entry had already been created.

Is it safe enough to drop the db entries, then remove the portal files so that I an attempt a clean re-install?

Thanks in advance!

[3Di]

Great tutorial!

I have a problem. I attempted to install a portal mod, but received errors. I tried to reinstall where I thought the errors would be fixed, but I got a error that the db entry had already been created.

Is it safe enough to drop the db entries, then remove the portal files so that I an attempt a clean re-install?

Thanks in advance!

simply do not run those SQL queries again and go ahead.

[fimo]

Hi,

i was wondering if its possible to use phpMyadmin to take a backup of my phpbb3 board,
but ONLY backup the member list,all of their posts.

the idea is that i would like to install a fresh phpbb3 board and then "copy" alle my users,their posts
and then restore them via phpMyadmin, but i dont know if thats possible / how ?

[sathsara]

I have a live board and I wanna use it offline at home. Every time I tried to export the sql using phpmyadmin the browser get stacked and stops responding. I download the sql backup file from the host but it gave me errors. Any idea?

[sathsara]

Hi,

i was wondering if its possible to use phpMyadmin to take a backup of my phpbb3 board,
but ONLY backup the member list,all of their posts.

the idea is that i would like to install a fresh phpbb3 board and then "copy" alle my users,their posts
and then restore them via phpMyadmin, but i dont know if thats possible / how ?

It will be really useful,

[carlyse_09]

Thanks for all the information regarding this matter.I really learn a lot on how to use it..Im glad to find this site.

[joker400]

Thanks man it a good tutorial

[ThunderCrew]

Hi,

i was wondering if its possible to use phpMyadmin to take a backup of my phpbb3 board,
but ONLY backup the member list,all of their posts.

the idea is that i would like to install a fresh phpbb3 board and then "copy" alle my users,their posts
and then restore them via phpMyadmin, but i dont know if thats possible / how ?

It will be really useful,

Um yeah when doing your back up only select those tables
in phpbb3 maintinence area when doing the databse back up you have the option of select all OR just mark the ones you want to back up.

Ooops actualy its not entirley accurate...
You would have to do one and then the other.
You can highlight one back it up then highlight the other then back it up though instead of entire databse.
Or if tables you want are ontop of each other you can highlight both and back them up.

[easygo]

Hi,

i was wondering if its possible to use phpMyadmin to take a backup of my phpbb3 board,
but ONLY backup the member list,all of their posts.

the idea is that i would like to install a fresh phpbb3 board and then "copy" alle my users,their posts
and then restore them via phpMyadmin, but i dont know if thats possible / how ?

It will be really useful,

Um yeah when doing your back up only select those tables
in phpbb3 maintinence area when doing the databse back up you have the option of select all OR just mark the ones you want to back up.

Ooops actualy its not entirley accurate...
You would have to do one and then the other.
You can highlight one back it up then highlight the other then back it up though instead of entire databse.
Or if tables you want are ontop of each other you can highlight both and back them up.

Should be possible all in one go, using phpMyAdmin! Simply press and hold the Strg key on your
keyboard while selecting any tables you want to export from the drop down menu.

Hope this helps.

[obvios]

hi there...
this is my first time using phpmyadmin..
i've read through the tutorial but i dont understand..
i open phpmyadmin and this window come out...




what i need to do next?

i was planning to insert this

Code: Select all

INSERT INTO phpbb_config (config_name, config_value) VALUES ('reimg_max_width', '640'), ('reimg_max_height', '480'), ('reimg_rel_width', '0'), ('reimg_swap_portrait', '1'), ('reimg_zoom', '_litebox');

where i need to store it?
please help me..
totally dont know and i'm ready to learn right now..

[easygo]

Just click the database name on the left menu and follow the How to in the first post, see ::

What to do once in phpMyAdmin

[tristaneiseo]

thanks for this Tutorial... it is great!

[obvios]

Just click the database name on the left menu and follow the How to in the first post, see ::

that's mean i need to click on Config.php and insert all the code below?

Code: Select all

INSERT INTO phpbb_config (config_name, config_value) VALUES ('reimg_max_width', '640'), ('reimg_max_height', '480'), ('reimg_rel_width', '0'), ('reimg_swap_portrait', '1'), ('reimg_zoom', '_litebox');

[easygo]

Config.php? No, that means click on the SQL tab and then paste any sql command line you want to run.

[obvios]

Config.php? No, that means click on the SQL tab and then paste any sql command line you want to run.

sorry.. i really dont know.. that's why i'm asking
u mean this one?



then i need to paste all of these?

Code: Select all

INSERT INTO phpbb_config (config_name, config_value) VALUES ('reimg_max_width', '640'), ('reimg_max_height', '480'), ('reimg_rel_width', '0'), ('reimg_swap_portrait', '1'), ('reimg_zoom', '_litebox');

sorry again.. i really donno..